G Guest Oct 17, 2007 #1 Tax calculations to be calculated @ 10% unless an adjacent cell contains "N" to indicate no tax is to be calculated.
Tax calculations to be calculated @ 10% unless an adjacent cell contains "N" to indicate no tax is to be calculated.
D David Biddulph Oct 17, 2007 #2 =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.
=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.
