Hi,
I am working on Excel Sheet that contains Marks of Students. I am calculating A+, A, B, C & D Grades using IF Statement. I am using the following formula to calculate:
=IF(H37>=80,"A+",IF(H37>=70,"A",IF(H37>=60,"B",IF(H37>=50,"C",IF(H37<=40,"D")))))
In all cells the value is according to formula but in Cell "H37" it showing FALSE instead of "D". Can anyone tell me how to correct it and what I am doing wrong? What should I write if there is a mistake in it?
Thanking you in advance.
Shahzad Zameer
You missed between 41 to 49 in the If statement that is why it is showing as FALSE
=IF(H37>=80,"A+",IF(H37>=70,"A",IF(H37>=60,"B",IF(H37>=50,"C",IF(H37<=40,"D"," ")))))
Use this formula if you enter between 41 to 49, it will show blank
Last edited by chandy123987; 12-02-2019 at 03:49 AM.
If solved press * add reputation
Try
=IF(H37>=80,"A+",IF(H37>=70,"A",IF(H37>=60,"B",IF(H37>=50,"C",IF(H37>=40,"D")))))
Or simple one
=LOOKUP(H37,{0,"D";50,"C";60,"B";70,"A";80,"A+"})
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank You so much for your quick response and help. Be Blessed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks