can you plz write the formula for me q26

26. We will now try a Nested IF statement with a Nested AND and a Nested OR. We will place this is cell 17 IF the Location is Cass Lake AND the Met Goal? is No, the New Goal will be a 5% increase over the (Hint: Actual x 1.05) actual IF the Location is Baudette OR the Level is Excellent, the New Goal will be a 15% increase over the actual (Hint: Actual x 1.15) . All others will have a New Goal of 10% over the actual (Hint: Actual x 1.1) Remember: Logical Test-Comma-Value IF True-Comma-next IF Write it down: AND Ledical Test-both conditions must be met Value if True Remember: Logical Test-Comma-Value IF True-Comma-next IF Write it down: IF(ANDL Logical Test-both conditions must be met Value if True IF(ORL Lozical Test-either condition must be met Value if True Final Answer, Value if false, close off IF parentheses-2 IF statements open-2 Closing Parentheses Page 10 of 11 Your Goal sheet should now look like: D T F 4 Ether Eligible for Actuall Location Geal Actual Goal? Guall Both Goals? Bonus Goals Level usate Barbetta PROM Both Goals! TRA FALSE TRUE P FALSE Ownedy Keeping ho CHILDRE Wa 100d Baden agad ng TO Garby Dybde Outtending Eigible in Celale 10.0 TRUE TIME spe 27. Save, close Excel and submit this file to the Canvas assignment. 111111 Mat + New Gol 160 HAPPY The of