1 2 3 184 IF function 185 in the yellow cell immediately below write a formula that sets the cell to 'l' if H186 equals 2 and to '2' otherwise'. 186 2 187 in the yellow cell immediately below write a formula that sets the cell to 'Dick' if 186*J186 equals H186+5 and to 'Jane' otherwise. 188 Dick 189 190 Logical Functions 191 In the yellow cell immediately below write a formula that sets the cell to 'Yes' if either (186 or J186 equals 2 and to 'No' otherwise. 192 199 1 w N 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 A 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 A 203 B 2 204 A 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 Hare 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. A 1 207 Copy cell B208 down to cell B209. B 2 208 209 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 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 218 w N A A 3 B A 4 B 1 20 5 1 2 3 184 IF function 185 in the yellow cell immediately below write a formula that sets the cell to 'l' if H186 equals 2 and to '2' otherwise'. 186 2 187 in the yellow cell immediately below write a formula that sets the cell to 'Dick' if 186*J186 equals H186+5 and to 'Jane' otherwise. 188 Dick 189 190 Logical Functions 191 In the yellow cell immediately below write a formula that sets the cell to 'Yes' if either (186 or J186 equals 2 and to 'No' otherwise. 192 199 1 w N 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 A 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 A 203 B 2 204 A 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 Hare 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. A 1 207 Copy cell B208 down to cell B209. B 2 208 209 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 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 218 w N A A 3 B A 4 B 1 20 5