Alternative for IF function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set add function ignore #N/A 1
If........then...... 2
Inserting Symbols with IF Function. 4
Excel Need Countifs Formula Help 0
Excel Repeating a RAND() function under certain conditions 0
Average with multiple conditions 4
Function Argument Question 4
How to copy the function SUM but offseted in 7 columns 2

Back
Top