Wednesday, August 22, 2012

yogi_Convert Numeric Grade To Letter Grade Per Specified Rule Or Conversion Table

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #710   Aug 22, 2012     www.energyefficientbuild.com.

user archeraj2 said: (http://productforums.google.com/forum/?zx=ahxxx0f1ye6h#!category-topic/docs/spreadsheets/Om3lijdbF-M)
multiple ifs not working
i am trying to get a command working to change percentage into a grade but no matter what the percentage is is will only post an A for my grade
=IF(100.00%>=E7>=95.00% ; "A" ; IF(94.99%>=E7>=90.00% ; "A-" ; IF(89.99%>=E7>=85.00% ; "B" ; IF(84.99%>=E7>=80.00% ; "B-" ; IF(79.99%>=E7>=75.00% ; "C" ; IF(74.99%>=E7>=70.00% ; "C-" ; IF(69.99%>=E7>=65.00% ; "D" ; IF(64.99%>=E7>=60.00% ; "D-" ; IF(59.99%>=E7 ; "F")))))))))
-----------------------------------------------------------------------
following is a solution to a bit more generalized problem