May 11 2021 12:58 AM
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"))))))))))
May 11 2021 01:36 AM
SolutionBrackets 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"
)))))))))))
May 11 2021 01:46 AM
@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.
May 11 2021 01:36 AM
SolutionBrackets 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"
)))))))))))