This calculation works:
IF(A3<1,A3*10,IF(A3<5,20))
Why won't this one:
if(A4<1,B4==0,if(A4>1<=2,40,if(A4>2<=3,60,if(A4>3<=4,100,if(A4>4<=5,125)))))
If you want me to send you the table that I am trying to make this work in, just let me know. Thanks,
Elaine.