Expand my Community achievements bar.

Why won't my "if" expression work?

Avatar

Former Community Member
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.
1 Reply