Sales tax formula

**opazita** · 01-22-2012, 07:05 AM

Hey guys,
I need a formula for the following issue:
the sales tax in a Purchase order i want it to be like that, if it has the word "included" chosen from a drop down menu, then the sales tax cell shall be 0. Otherwise, if "included" is not chosen then sales tax shall be normally calculated.

can anybody help with this problem please ASAP!!

Also the excel sheet is attached.

Thanks in advance.sample mec po 11.xlsx

**DBY** · 01-22-2012, 07:29 AM

Hello
If for example your drop down list was in Cell I4 then the following formula in G42 should work.

=IF($I$4="Included",0,(G41*0.1))

Hope this helps.

**opazita** · 01-22-2012, 07:36 AM

thanks but did not work!

**DBY** · 01-22-2012, 07:41 AM

Hi
Not sure what to suggest as it works perfectly on your example file I downloaded. What result is it returning?

**royUK** · 01-22-2012, 08:56 AM

It works if the formula refers to the correct cell

=IF(E42="included",(G41*0.1),"")

**DBY** · 01-22-2012, 09:05 AM

Thanks royUk for pointing that out. Silly of me. Never noticed the drop down in E42. Need my eyes tested. Should still have worked though with drop down in I4 which I mentioned as an example.

Regards DBY