# How to create a IF between numbers?

Topic Labels: Formulas
4856 4
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hi.

Is it possible to set a conditional formatting with 3 results?

If the result of 80 or more, the cell shows “Go”
If the result is lower than 80, but higer than 50, the cell shows “Caution”
If the result is lower than 50, the cell shows “Run”.

Thanks

4 Replies 4
9 - Sun

Assuming you have a field called “Result”, create a formula field with this as the formula:

``````IF(
{Result} >= 80,
"Go",
IF(
{Result} >= 50,
"Caution",
"Run"
)
)
``````

If you don’t have a field called “Result” you can do the same thing with the source fields instead, something like this:

``````IF(
SUM({Field 1},{Field 2}) >= 80,
"Go",
IF(
SUM({Field 1},{Field 2}) >= 50,
"Caution",
"Run"
)
)
``````

Take a few minutes to read this, it’ll help sooooo much:

### Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

5 - Automation Enthusiast

Thanks for the answer. But I’ve made that, and it didn’t worked. I’ve read the formula field reference, and the conditional formating reference, and it didn’t worked. =(

My mistake! I placed a space between the `IF` and the `(`

I’ve edited my previous answer and tested it:

5 - Automation Enthusiast

Worked. Thanks 😃 Now I have the ultimate Airtable to use in my negotiations (I’ll know exacly, how much discount can I give, and how much everything will cost to me and to my clients). 😃