Hello,
My partner has asked me to help with a spreadsheet she uses in her role as a Teaching Assistant. The spreadsheet is used to calculate 'points' for good work/behaviour which are then converted to a cash value (which can be redeemed for various awards/prizes).
The formula they are using is as follows:
=(IF(AND(D51>=0,D51<=25),0,IF(AND(D51>=26,D51<=30),1,IF(AND(D51>=31,D51<=34),3,IF(AND(D51>=35,D51<=100),5,"")))))+E51+F51+G51
D51 is the total points awarded for a student in that week.
What they have, however, is 2 groups of students where the parameters are different. These are 'TEC1' and 'TEC2' (these are listed in Column C in the spreadsheet). They will be awarded £1 if they get between 30-35 points and £3 if they get between 35-39 points.
Essentailly she needs a formala which says IF its TEC1 or TEC2 the rules are x , if not the rules are y.
Thanks in advance.
Will M
My partner has asked me to help with a spreadsheet she uses in her role as a Teaching Assistant. The spreadsheet is used to calculate 'points' for good work/behaviour which are then converted to a cash value (which can be redeemed for various awards/prizes).
The formula they are using is as follows:
=(IF(AND(D51>=0,D51<=25),0,IF(AND(D51>=26,D51<=30),1,IF(AND(D51>=31,D51<=34),3,IF(AND(D51>=35,D51<=100),5,"")))))+E51+F51+G51
D51 is the total points awarded for a student in that week.
What they have, however, is 2 groups of students where the parameters are different. These are 'TEC1' and 'TEC2' (these are listed in Column C in the spreadsheet). They will be awarded £1 if they get between 30-35 points and £3 if they get between 35-39 points.
Essentailly she needs a formala which says IF its TEC1 or TEC2 the rules are x , if not the rules are y.
Thanks in advance.
Will M
