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.