Multiple IF AND statements

+5

I'm trying to compare data from 2 columns to result in a rating.

I'm trying to break it down first before going crazy with multiple IF AND statements. Below is the first working example:

IF(AND(A=100, B=100), 5, BLANK())

Below are the conditions

I have tried the following and it's not working

IF(AND(A=100, B=100), 5, IF(OR(AND(A<=100, A>=97), AND(B<=100,B>=78))), 4, BLANK()))

+31

Hm could you give this a shot?

IF(
  AND(
    A=100, 
    B=100
  ), 
  5,
  IF(
    AND(
      A<=100, 
      A>=97
      B<=100,
      B>=78
    ),
    4
  )
)

Adam, Airtable Consultant - thetimesaving.company

+31

Hm could you give this a shot?

IF(
  AND(
    A=100, 
    B=100
  ), 
  5,
  IF(
    AND(
      A<=100, 
      A>=97
      B<=100,
      B>=78
    ),
    4
  )
)

Missing comma after `A>=97`, sorry. Can't edit posts if not I'd fix it

Adam, Airtable Consultant - thetimesaving.company

+5

Missing comma after `A>=97`, sorry. Can't edit posts if not I'd fix it

Hi Adam, I tried this and it didn't work. I ended up doing it manually.

+31

Hi Adam, I tried this and it didn't work. I ended up doing it manually.

Roger that, glad you got it working

Adam, Airtable Consultant - thetimesaving.company

+5

Roger that, glad you got it working

Thanks for trying to help!

Sign up