If Greater, Equal or Less Than Formula

[RYANE]

Hi,

I am trying to get a cell to show me the following:

If cell AI2 is greater than O2 say "OVER" in cell A2
If cell AI2 is less than O2 say "ACTIVE" in cell A2
Or, if cell AI2 is equal to O2 say "CLOSED" in cell A2

I am currently using the formula =IF(AI2>=O2,"OVER",IF(AI2<=O2,"ACTIVE,IF(AI2=O2,"CLOSED")))

It would seem that the formula for two cells equaling the same value is not working.

Any help would be appreciated. Thanks!

 

[Joe4]

That is because you are using Greater Than or equal to (>=) instead of just Greater Than (>).
Same thing with less than.

Try:

[COLOR=#333333]=IF(AI2>O2,"OVER",IF(AI2 < O2,"ACTIVE","CLOSED"))[/COLOR]

Notice how I just use the second argument of the second IF for Closed instead of nesting another IF.
If it is not greater than or less than, the only choice left is equal to.

 

[Jonmo1]

AI2 being equal to O2 is already included in the first IF criteria AI2>=O2.
That says if AI2 is greater than OR 'EQUAL TO' O2, then return OVER

You probably want to change both of those comparisons to remove the = part.
1st if tests >, 2nd if tests <

And you don't actually need the 3rd IF.
If neither > or < is true, then it MUST be =.

 

[RYANE]

Thank you so much! I can't believe it was something that simple. "The more you know!"

That is because you are using Greater Than or equal to (>=) instead of just Greater Than (>).
Same thing with less than.

Try:

[COLOR=#333333]=IF(AI2>O2,"OVER",IF(AI2 < O2,"ACTIVE","CLOSED"))[/COLOR]

Notice how I just use the second argument of the second IF for Closed instead of nesting another IF.
If it is not greater than or less than, the only choice left is equal to.