Tuesday, August 28, 2012

yogi_Compute Stats in A Computed Column Based On Entries in Multiple Columns

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

user B-House said: (http://productforums.google.com/forum/?zx=4uvknqql63q3#!category-topic/docs/spreadsheets/jBW6-R8PRXI)
Array Formula with If forumla 
I am trying to create a formula that will determine a student's Tier (1,2,3) based on 5 criteria.
I have 5 columns(F:J) that serve as the Criteria for K
  • F is the number of D grades
  • G is the number of F grades
  • H is the number of unexcused absences
  • I is the number of tardies
  • J is the number of behavior referrals
Column K is the Tier Level (1, 2, 3)
  • I would like column K to fill with a 1 if:
    • F:J = 0
  • I would like column K to fill with a 2 if:
    • G+H+J = 0
    • AND I < 3
  • I would like column K to fill with a 3 If:
    • G+H+J > 1
    • OR I >3
Does this make sense? I shared a link to my form just in case. 
Thanks in advance! You all do great work and I truly appreciate the help.
Carl
---------------------------------------------------------------------------------------------

following is a solution to the problem