SOLVED

Request help with IF Formula in excel

Copper Contributor

Can someone pls advise what is the error in this IF Formula? 

 

=IF(D2>85, "'=A+" , IF (D2 > 80, "A", IF (D2>75,  "'=A-", IF (D2>70, "'=B+", IF (D2>65, "B", IF (D2>60, " '=B-", IF (D2>60,  " '=C+", IF (D2>55, "C", IF(D2>50, "D", IF(D2>45, "E", IF D2<40, "F"))))))))))

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@rinirock19 

Brackets were not paired

=IF(D2>85,"'=A+",
IF(D2>80,"A",
IF(D2>75,"'=A-",
IF(D2>70,"'=B+",
IF(D2>65,"B",
IF(D2>60," '=B-",
IF(D2>60," '=C+",
IF(D2>55,"C",
IF(D2>50,"D",
IF(D2>45,"E",
IF(D2<40,"F","N/A"
)))))))))))
Thank You! Really appreciate that.

@rinirock19 , you are welcome

Another point you have two conditions D2>60, only first of them returns result. Plus it is not defined what to return between 40 and 45.

Another variant could work

=LOOKUP(D2,
  {0,40,45.1,50.1,55.1,60.1,65.1,70.1,75.1,80.1,85.1},
  {"F", "E","D","C"," '=C+"," '=B-","B","'=B+","'=A-","A","'=A+"}
  )

the only the logic shall be corrected as mentioned above, I don't know what it shall be.

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@rinirock19 

Brackets were not paired

=IF(D2>85,"'=A+",
IF(D2>80,"A",
IF(D2>75,"'=A-",
IF(D2>70,"'=B+",
IF(D2>65,"B",
IF(D2>60," '=B-",
IF(D2>60," '=C+",
IF(D2>55,"C",
IF(D2>50,"D",
IF(D2>45,"E",
IF(D2<40,"F","N/A"
)))))))))))

View solution in original post