Skip to main content

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

  1. IF A=100 AND B=100, rate 5
  2. IF A<100, A>=97 AND B<100, B>=97, rate 4
  3. IF A<97, A>=94 AND B<97, B>=94, rate 3

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

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

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

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. 

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


Roger that, glad you got it working

Roger that, glad you got it working


Thanks for trying to help!

Reply


Terms & Conditions