## 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.

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