Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to create a IF between numbers?

Topic Labels: Formulas
3401 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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...

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:

1870475be7bb1a6697d7f0c2d086120aab21dd5e.png

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). 😃