Calculation based on Y or N Values
 

Tax calculations to be calculated @ 10% unless an adjacent cell contains "N"
to indicate no tax is to be calculated.

Calculation based on Y or N Values
 

=IF(B1="N","",A1*10%)
or
=IF(B1="N",0,A1*10%)
depending on whether you want a blank or a zero if no tax.
--
David Biddulph

"Malcolm McMaster" wrote in
message ...
Tax calculations to be calculated @ 10% unless an adjacent cell contains
"N"
to indicate no tax is to be calculated.

Calculation based on Y or N Values
 

Try this:

A1 = 100
B1 = N or empty

=(B1<"n")*0.1*A1

--
Biff
Microsoft Excel MVP


"Malcolm McMaster" wrote in
message ...
Tax calculations to be calculated @ 10% unless an adjacent cell contains
"N"
to indicate no tax is to be calculated.