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