# Formula using <>

Options

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:

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

Tags:

• ✭✭
Options

<> is the same as "not equal"

• Options

Ah, ok. Thank you!

• Options

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?

• ✭✭✭✭✭✭
Options

I would suggest something like this...

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.

• Options

Oh, perfect! Thank you, Paul!

• ✭✭✭✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!