Formula using <>

Laurie Bearden

I'm trying to create a formula that will return a red, yellow, or green ball. I saw the below formula on someone else's comment a while back, but wasn't able to find it today. Right now my formula is:

=IF([Late Tasks]@row > 0.75 * [Total Tasks]@row, "Red", IF([Late Tasks]@row <> 0.5, "Yellow", "Green"))

Can someone tell me what the <> does in this formula?

Ryan Nix

<> is the same as "not equal"

Laurie Bearden

Ah, ok. Thank you!

Laurie Bearden

So in that sense, I am saying if the late tasks are greater than 75%, turn it red, if it is not equal to 50%, turn it yellow, if it doesn't apply to either, turn it green.

Is there any way to do a formula that says if it is between two numbers (.75 and .25) to turn it yellow?

Paul Newcome

I would suggest something like this...

=IF([Late Tasks]@row > 0.75 * [Total Tasks]@row, "Red", IF([Late Tasks]@row > 0.25, "Yellow", "Green"))

When nesting IF statements, they read from left to right and stop on the first true value. So if your first argument is greater than 0.75, then by default it must be less than 0.75 if it is moving on to the second IF. Since less than 0.75 is already implied by making it this far, we only need to specify greater than 0.25.

Laurie Bearden

Oh, perfect! Thank you, Paul!

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.