Thanks so VERY much Max. You rock....Worked exactly.

"Max" wrote:

Assume in B4 down will be the indicators: y, n
In say, C4: =IF(B4="y",$B$2,0)
Format C4 as percentage
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"thechooks" wrote:
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