11 IFERROR function 12 Write a formula using IFERROR in the yellow cell immediately below that...

Transcribed Image Text:

11 IFERROR function 12 Write a formula using IFERROR in the yellow cell immediately below that results in '2' when you divide H213 by 1213". 13 214 215 ISERROR function 1 0 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 218 219 Write formulas that calculates the following for each scenario 220 Name Scenario 1 Scenario 2 Scenario 3 221 222 AB 4 4 3 0 2 2 223 C 4 4 4 224 225 226 227 228 229 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 237 No No 7 5 238 20 5 For each scenario, If either A-3 or B=0 are true, set the cell value to 1 otherwise to 2 For each scenario, If both A-C and B 0, set the value to 1 otherwise 2 For each scenario, divide A by B and if the result is an error ('#DIV/0!") set the yellow cell to '4' 239 Write a SUMIF function in B242 that sums the value in the shaded range if the related cell in 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 244 245 246 247 248 11 IFERROR function 12 Write a formula using IFERROR in the yellow cell immediately below that results in '2' when you divide H213 by 1213". 13 214 215 ISERROR function 1 0 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 218 219 Write formulas that calculates the following for each scenario 220 Name Scenario 1 Scenario 2 Scenario 3 221 222 AB 4 4 3 0 2 2 223 C 4 4 4 224 225 226 227 228 229 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 237 No No 7 5 238 20 5 For each scenario, If either A-3 or B=0 are true, set the cell value to 1 otherwise to 2 For each scenario, If both A-C and B 0, set the value to 1 otherwise 2 For each scenario, divide A by B and if the result is an error ('#DIV/0!") set the yellow cell to '4' 239 Write a SUMIF function in B242 that sums the value in the shaded range if the related cell in 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 244 245 246 247 248