Friday, July 20, 2012

yogi_Compute Score Of Entities Row By Row Based On Set Up In Evaluation Table

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #642   Jul 20, 2012     www.energyefficientbuild.com.

user PV-TT said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/CRuqJcufgmU)
Dear Sir or Madam,
Please help me, in Spreadsheet I have one column as below:
EVALUATION
BAD
VERY BAD
NEUTRAL
GOOD
BAD
EXCELLENT
How can I caculate value of EVALUATION? The conditions are: EVALUATION = the lowest value of the column (VERY BAD < BAD < NEUTRAL < GOOD < EXCELLENT)
Thanks a lot.
----------------------------------------------------------------------------------------------
Let me see if my following solution to the problem answers PV-TT's question