Tuesday, April 23, 2013

yogi_Compute Value For Decision Based On Two Variables

                                          Google Spreadsheet   Post  #1148
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 24, 2013
user Darsha :(http://productforums.google.com/forum/?zx=crpyw0e3sdva#!category-topic/docs/spreadsheets/O-SUt1mnE4U)
formula help (need to consider two columns)

Here is the link to the spreadsheet. I need column B to tell me whether the text was independent, instructional, or hard for the student, based on two pieces of information: column E AND column F.

The rules are:
Comprehension (column F)  9-10 AND accuracy(column E)  98-100% = Independent
Comprehension 9-10 AND accuracy 95-97% = Instructional
Comprehension 9-10 AND accuracy below 95% = hard

Comprehension 7-8 AND accuracy 98-100% = Independent
Comprehension 7-8 AND accuracy 95-97% = instructional
Comprehension 7-8 AND accuracy below 95% = hard 

Comprehension 5-6 AND accuracy 98-100% = Instructional
Comprehension 5-6 AND accuracy 95-97% = hard
Comprehension 5-6 AND accuracy below 95% = hard

Comprehension 0-4 AND accuracy 98-100% = hard
Comprehension 0-4 AND accuracy 95-97% = hard
Comprehension 0-4 AND accuracy below 95% = hard

So, Mickey Mouse should have an instructional level.
Bob should be independent
ferb, alice, and tinker should all be hard
peter pan should be independent
Zee should be hard
Ace should be instructional.

Please help!

Thank you,

Darsha: following is a solution ... please note that my results as presented in yogi_Sheet1 do not all agree with yours as in Sheet1 ... so please check them out