Calculation based on Y or N Values

[Malcolm McMaster]

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

 

[David Biddulph]

=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.

 

[T. Valko]

Try this:

A1 = 100
B1 = N or empty

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