I'd like to know how to put this condition in a cell
IF 100<A1<200 THEN
1
ELSEIF 200<A1<300 THEN
2
ELSE any other value of U10
0
Thanks for any help!
I'd like to know how to put this condition in a cell
IF 100<A1<200 THEN
1
ELSEIF 200<A1<300 THEN
2
ELSE any other value of U10
0
Thanks for any help!
"What does else any other value of U10" mean?
Try
=IF(AND(A1>100,A1<200),AND(A1>200,A1<300),2,U10))
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
you could try this... =LOOKUP(A1,{0,100,200,300},{0,1,2,0})
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
For three outputs, the IF function works well. An alternative approach, especially if this is going to expand to multiple possible outputs is to use a lookup table and one of Excel's lookup functions (VLOOKUP() is probably the first one people learn: https://support.office.com/en-us/art...8-93a18ad188a1 ) Pay particular attention to how Excel performs the lookup when the 4th argument is TRUE to understand how this will handle you "between" conditions.
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks