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
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
No comments:
Post a Comment