Help

Re: Nested IF Statement For Greater Than Or Equal To

1107 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rory_Sacks
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi All, I am really new to formulas and I am trying to do along string IF statement. Can anyone help me identify where this is going wrong? I looked and read through other topics and just can’t get it to work. I essentially want this to go all the way from 1 to 100 with greater than or equal to all the way up.

IF({Security Price (from Search Criteria)}>85,“1”)

({Security Price (from Search Criteria)}>=70,<=84,”2”)

))

2 Replies 2

Use this pattern:

IF(
   {Security Price (from Search Criteria)} > 85, 
   "1",
   IF(
      {Security Price (from Search Criteria)} >= 70,
      "2",
      IF(
         ...
      )
   )
)

You don’t have to check if something is less than 85 twice.

Rory_Sacks
5 - Automation Enthusiast
5 - Automation Enthusiast

This worked! thanks so much!

Is there an AverageA function in Airtable? I would like to average those cells that have the formula in it.