=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 manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History