A B C D E F G H 183 184 IF function J 185 In the yellow cell immediately below write a formula that sets the cell to '1' if H186 equals 2 and to '2' otherwise'. 186 1 2 3 187 In the yellow cell immediately below write a formula that sets the cell to 'Dick' if 1186*1186 equals H186+5 and to 'Jane' otherwise. 188 189 190 Logical Functions 191 In the yellow cell immediately below write a formula that sets the cell to 'Yes' if either 1186 or J186 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 A 199 B 200 A 201 Write a formula in the yellow cell immediately below the sums the values Column I of the grey range where the value in column 'H' is 'A'. 202 A 1 203 204 B 2 2 + ACCOUNTS Balance Sheet FSA Balance Sheet SFAM Balance Sheet DISRUPTIVE DIGITIZATION EXCEL Conditional Functions DAT