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

[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

 

[Max]

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

 

[Don Guillett]

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

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

 

[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

 

[thechooks]

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

 

[John]

OOPS forgot B2
=IF(B5="Y",A5*B2,A5)
Regards

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

 

[Max]

Welcome. Pl press the YES button in that response. Thanks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik