Forum Discussion
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 F.
PLEASE HAVE A LOOK, NO ONE WAS ABLE TO FIND THE PROBLEM FOR ME! Everyone says the formula is right but for me all i get is F
Please look at my Attachment PLZ
THANK YOU
2 Replies
In percentages, underlying value for the 100% is 1, so if the percentage is below 100%, its underlying value will be less than 1 e.g. 90% is equivalent to 0.9 not 90.
You will know this if you change the format of the column G as General.
Change your formula to this and it will work correctly.
=IF([@Total]>0.9,"A+",IF([@Total]>0.85,"A",IF([@Total]>0.8,"A-",IF([@Total]>0.77,"B+",IF([@Total]>0.73,"B",IF([@Total]>0.7,"B-", IF([@Total]>0.6,"C", "F")))))))
