I have this formula,
=IF(G14<=1,0,IF(G14<=2,5,IF(G14<=3,10,IF(G14=4,15 ,0)))) , if the data is 3.5
it returns 0, instead of 10. All other decimals seem to work. Any ideas what
I am doing wrong?
Thanks,