=if(c2="y",$b$2,0)
or

=if(c2="y",(1+$b$2)*d2,0)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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