Nested If statement to find greater than but less than numbers
Hi,
I had this formula that works well:
=IF(M20=1.5,"3",IF(AND(M20=1,M20<1.5),"2",IF(AND (M20=0.5,M20<1),"1",IF(AND(M20=0.25,M20<0.5),"0. 5",IF(M20<=0.25,"0.5","error")))))
so I thought I will add another cell for it to check in the AND part so
the formula looked like this:
=IF(AND(M19=1.5,Q19=3),"3",IF(AND(M19=1,M19<1.5 ,Q19=2,Q19<3),"2",IF(AND(M19=0.5,M19<1,Q19=1,Q1 9<2),"1",IF(AND(M19=0.25,M19<0.5,Q19=0.5,Q19<1), "0.5",IF(AND(M19<=0.25,Q19<0.5),"0.5","error") ))))
But now it just returns "error"
Have I dont something illegal here?
Why cant it just after looking at m19 cell, just look at q19 also
before displaying its result?
Cheers for advice,
Aaron.
|