Nested IF Statement For Greater Than Or Equal To

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”)

))

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.

1 Like

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.