How to create a IF between numbers?


#1

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


#2

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:


#3

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


#4

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

I’ve edited my previous answer and tested it:


#5

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