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.

Nested IF Statement For Greater Than Or Equal To

Topic Labels: Formulas
365 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

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.