OOPS forgot B2
=IF(B5="Y",A5*B2,A5)
Regards
"John" wrote in message
...
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
"thechooks" wrote in message
...
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