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