How do I include $x.89 value in the below formula to add $0.05 with the $x.09 & $x.59 value?
Y yk Jul 9, 2007 #1 How do I include $x.89 value in the below formula to add $0.05 with the $x.09 & $x.59 value?
T Toppers Jul 9, 2007 #2 one way: =INT((10*A1)+1)/10-0.01+OR(MOD(INT(A1*10)-(INT(A1)*10),5)=0,MOD(INT(A1*10)-(INT(A1)*10),8)=0)*0.05
one way: =INT((10*A1)+1)/10-0.01+OR(MOD(INT(A1*10)-(INT(A1)*10),5)=0,MOD(INT(A1*10)-(INT(A1)*10),8)=0)*0.05
