Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Excel If function alternative | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |