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

Dez,

Try

IF (AND(0<A1;A1<=1,5);E1;B1).

--
HTH

Bob Phillips

"Dez" wrote in message
...
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