Help

Re: How to create a IF between numbers?

1605 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucas_Pereira
5 - Automation Enthusiast
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

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

Lucas_Pereira
5 - Automation Enthusiast
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:

1870475be7bb1a6697d7f0c2d086120aab21dd5e.png

Lucas_Pereira
5 - Automation Enthusiast
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). 😃