Forum Discussion

Help1175's avatar
Help1175
Copper Contributor
Nov 28, 2019

MAJOR ISSUE' My formula is always giving me an F, Even though when thers do it its correct

=IF([@Total]>90,"A+",IF([@Total]>85,"A",IF([@Total]>80,"A-",IF([@Total]>77,"B+",IF([@Total]>73,"B",IF([@Total]>70,"B-", IF([@Total]>60,"C", "F")))))))   This is what i post and all my numbers go to...
excel
Excel for web
Twifoo's avatar
Twifoo
Silver Contributor
Nov 28, 2019

Help1175 

I recommend you LOOK at the simple LOOKUP formula in H2 in the attached file, as shown in the snapshot below: 

Resources