I dont really see any difference between the 2 formulas?
<3=IF(F14="AB",D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2))
3 =IF(F14="AB",D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2))
The suggestion in #2 could also be shortened to...
if(E14<3,IF(F14="AB",D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2)),if(E14=3,IF(F14="AB", D14/1.04*0.04/2,IF(F14="ON",D14/1.12*0.12/2)),"")
Again though, I dont see the difference?
Bookmarks