Alternative for IF function
I'm trying to use the IF function to get a value when the logic condition is
a variable "greater than" and "smaller than". Ex: IF (0<A1<=1,5;E1;B1). But a
come acrosse a problem. I have a lot of logic conditions and i have tryed to
put a IF function inside an IF function, ex:
IF(0<A1<=1,5;E1;IF(1,5<A1<=2;IF(...;..;...).
But, unfortunatly it dosen't worked. Is there any alternative?
Thanks
|