View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
thechooks thechooks is offline
external usenet poster
 
Posts: 2
Default If percentage is 10% when y or 0% when n

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