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

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

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

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

=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

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

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

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

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

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

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

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

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
---
"thechooks" wrote:
Thanks so VERY much Max. You rock....Worked exactly.