Question

Please show the formulas and steps. I am using office 360

o o T А B C С D E G H 1 J K L M N Р R S 1 Name Score 1 Score 2 - Total Score - Pass/Fail Column1 Columi - 2 Den 28 32 3 Scott 19 29 4 Colin 13 33 5 Dustin 27 34 6 Mike 20 30 7 James 25 50 8 Yvette 15 48 9 Karl 27 39 10 Frank 14 28 11 12 Required 1: In column D, create a formula that will sum the total of the two scores. 2: In column E, create a formula that will return PASS if a student scores 20 or higher on Score 1 and 25 and higher on Score 2 or if the student scores 15 or higher on Score 1 and 13 30 or higher on Score 2, and FAIL otherwise. 3: In column F, create a formula that returns Good if the total score is 60 or more, satisfactory if the score is between 40 and 60, and po if the score is less than or equal to 14 40. Do not reference Column D in the formula. 15 4: In column G, enter a formula that will return the phrase "You performed fantastic!" for students who scored over 60 and "You performed okay." otherwise. Do not start your formula with an IF function. 16

Answer 1

Name	Score 1	Score 2	Total Score	Pass/Fail	Column 1	Column 2
Den	28	32	60	Pass	Poor	You performed Fantastic
Scott	19	29	48	Fail	Satisfactory	You performed okay
Colin	13	33	46	Fail	Satisfactory	You performed okay
Dustin	27	34	61	Pass	Good	You performed Fantastic
Mike	20	30	50	Pass	Satisfactory	You performed okay
James	25	50	75	Pass	Good	You performed Fantastic
Yvette	15	48	63	Pass	Good	You performed Fantastic
Karl	27	39	66	Pass	Good	You performed Fantastic
Frank	14	28	42	Fail	Satisfactory	You performed okay

Assume above data in excel and below are the formulae's for reference:-

Formulae for 1) - B2+C2

2) =IF(OR(AND(B2>=20,C2>=25), AND(B2>=15,C2>=30)),"Pass","Fail")

3) =IF(B2+C2>60,"Good", IF(AND(B2+C2>40,B2+C2<60),"Satisfactory","Poor"))

4) =SWITCH(TRUE, D2>=60,"You performed Fantastic","You performed okay")

Also attached the screen clippping for your reference:

E2 =IF(OR(AND(B2>=20,C2>=25), AND(B2>=15,C2>=30)),"Pass","Fail") H OH А 1 Name 2 Den 3 Scott 4 Colin 5 Dustin 6 Mike 7 James 8 Yvette 9 Karl 10 Frank 11 B с D E F G Score 1 Score 2 Total Score Pass/Fail Column 1 Column 2 28 32 60 Pass Poor You performed Fantastic 19 29 48 Fail Satisfactory You performed okay 13 33 46 Fail Satisfactory You performed okay 27 34 61 Pass Good You performed Fantastic 20 30 50 Pass Satisfactory You performed okay 25 50 75 Pass Good You performed Fantastic 15 48 63 Pass Good You performed Fantastic 27 39 66 Pass Good You performed Fantastic 14 28 42 Fail Satisfactory You performed okay

F2 fx =IF(B2+C2>60,"Good", IF(AND(B2+C2>40,B2+C2<60), "Satisfactory", "Poor")) H Formula B: B с D E F G 1 Name Score 1 Score 2 - Total Score Pass/FailColumn 1 Column 2 2 Den 28 32 60 Pass Poor You performed Fantastic 3 Scott 19 29 48 Fail Satisfactory You performed okay 4 Colin 13 33 46 Fail Satisfactory You performed okay 5 Dustin 27 34 61 Pass Good You performed Fantastic 6 Mike 20 30 50 Pass Satisfactory You performed okay 7 James 25 50 75 Pass Good You performed Fantastic 8 Yvette 15 48 63 Pass Good You performed Fantastic 9 Karl 27 39 66 Pass Good You performed Fantastic 10 Frank 14 28 42 Fail Satisfactory You performed okay 11