Formula using <>
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?
Answers

<> is the same as "not equal"

Ah, ok. Thank you!

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?

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.

Oh, perfect! Thank you, Paul!

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.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.4K Get Help
 61 Global Discussions
 46 Industry Talk
 384 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!