Hello !
I am looking for an excel formula or VBA code for the following :
If value is between x and y , then "1", else if value is between y and z; then "2", else.....
So far I was actually using IF(A1<=E1;1;IF(AND(A1>=E2;A1<=E3);2;IF(AND(..........
So basically, lots of if(and()) imbricated...