please explain and include all the functions Logical Functions 191 In the yellow cell...
80.2K
Verified Solution
Link Copied!
Question
Finance
please explain and include all the functions
Logical Functions 191 In the yellow cell immediately below write a formula that sets the cell to 'Yes' if either 1186 or 1186 equals 2 and to 'No' otherwise. 192 193 In the yellow cell immediately below write a formula that sets the cell to 'Yes' if both 1186*J186 and H186+5 equals 6 and to 'No' otherwise. 194 195 196 Conditional Calculation Functions 197 Write a formula in the yellow cell immediately below the counts the values in Column H of the grey range where the value is 'A'. 198 199 B 200 201 Write a formula in the yellow cell immediately below the sums the values Column 1 of the grey range where the value in column 'H' is 'A'. 202 203 204 205 Write a formula in the yellow cell immediately below that sums the values in Column 1 of the grey range whose value in Column H are the same as the value in Column C. 206 The formula in B208 should use a 'S' so that it can be copied down to B209. 207 Copy cell B208 down to cell B209. 208 3 209 B A 4 210 B 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". 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. 20 218 213 217 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 Logical Functions 191 In the yellow cell immediately below write a formula that sets the cell to 'Yes' if either 1186 or 1186 equals 2 and to 'No' otherwise. 192 193 In the yellow cell immediately below write a formula that sets the cell to 'Yes' if both 1186*J186 and H186+5 equals 6 and to 'No' otherwise. 194 195 196 Conditional Calculation Functions 197 Write a formula in the yellow cell immediately below the counts the values in Column H of the grey range where the value is 'A'. 198 199 B 200 201 Write a formula in the yellow cell immediately below the sums the values Column 1 of the grey range where the value in column 'H' is 'A'. 202 203 204 205 Write a formula in the yellow cell immediately below that sums the values in Column 1 of the grey range whose value in Column H are the same as the value in Column C. 206 The formula in B208 should use a 'S' so that it can be copied down to B209. 207 Copy cell B208 down to cell B209. 208 3 209 B A 4 210 B 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". 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. 20 218 213 217 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
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!