If percentage is 10% when y or 0% when n

T

thechooks

I am trying to apply 10%tax when tax needs to be applied (i.e. when next to
the item I have placed a y. If there is no tax to be added, (i.e. displayed
by an n, then I want it to display 0%. I have placed the 10% tax amount in a
cell on it's own, in this case B2,
Please help, this is driving me nuts ;)
Linda
 
J

John

Hi
Let say A5 is your price: B5 is Y or N: B2 your 10%.
=IF(B5="Y",A5*1.1,A5)
Try that.
HTH
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top