=IF(F5<=G5,1) this works but I want to beable to add to this (F5<=H5,2), (F5<=I5,3),(J5<=G5,4), (F5<=K5,5), (F5>=K5,6) How can I look at each variable in the cells to determine if answer is 1 or 2 or 3 or 4 or 5 or 6?

What would be the formula tying each together in one string?Help

edited by moderator: Emoved Eail address

Do you have a typo in your question? All but one of your conditions compares F5 to other cells. However, you have this odd one: (J5<=G5,4) Assuming that's a typo, you can use a Nested IF where your

value_if_falseis another IF:=IF(F5<=G5,1,IF(F5<=H5,2,IF(F5<=I5,3, etc.

Just make sure you close all of your parenthesis at the end.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History