B N 00 AN 210 5 211 IFERROR function 212 Write a formula using IFERROR in the yellow cell immediately below that results in '2' when you divide H213 by 1213". 213 1 0 214 215 ISERROR function 216 Write a formula using ISERROR in the yellow cell immediately below that subtracts 1217 from H217 if dividing H213 by 1213 results in an error and adds them otherwise. 217 20 5 218 219 Write formulas that oaloulates the following for each scenario 220 Name Scenario 1 Scenario 2 Scenario 3 221 A 4 4 3 222 B 0 2 2 223 4 4 4 224 225 For each scenario, If either A-3 or B:0 are true, set the cell value to 1 otherwise to 2 226 For each scenario, If both A-C and B0, set the value to 1 otherwise 2 228 229 For each scenario, divide A by B and if the result is an error (#DIV/0!') set the yellow cell to '4' 230 Hint: Excel uses ''as not equal to 231 232 Use the following table for this exercise. 233 234 Yes No 6 235 Yes Yes 4 236 No Yes 7 237 No No 5 238 239 Write a SUMIF function in B242 that sums the value in the shaded range if the related cellin column B is a 'Yes'. 240 Modify the formula in B242 such that it can be copied to C242 and the logic will work based on column C being a 'Yes'. 241 Copy B242 to C242. 242 243 227 0+ 0 B N 00 AN 210 5 211 IFERROR function 212 Write a formula using IFERROR in the yellow cell immediately below that results in '2' when you divide H213 by 1213". 213 1 0 214 215 ISERROR function 216 Write a formula using ISERROR in the yellow cell immediately below that subtracts 1217 from H217 if dividing H213 by 1213 results in an error and adds them otherwise. 217 20 5 218 219 Write formulas that oaloulates the following for each scenario 220 Name Scenario 1 Scenario 2 Scenario 3 221 A 4 4 3 222 B 0 2 2 223 4 4 4 224 225 For each scenario, If either A-3 or B:0 are true, set the cell value to 1 otherwise to 2 226 For each scenario, If both A-C and B0, set the value to 1 otherwise 2 228 229 For each scenario, divide A by B and if the result is an error (#DIV/0!') set the yellow cell to '4' 230 Hint: Excel uses ''as not equal to 231 232 Use the following table for this exercise. 233 234 Yes No 6 235 Yes Yes 4 236 No Yes 7 237 No No 5 238 239 Write a SUMIF function in B242 that sums the value in the shaded range if the related cellin column B is a 'Yes'. 240 Modify the formula in B242 such that it can be copied to C242 and the logic will work based on column C being a 'Yes'. 241 Copy B242 to C242. 242 243 227 0+ 0