Question

N174 X f L M N o Р Q R s T U 183 А B D E F H к 169 IF function 170 In the yellow cell immediately below write a formula that sets the cell to 'l' if H171 equals 2 and to '2' otherwise 171 2 3 172 In the yellow cell immediately below write a formula that sets the cell to 'Dick' if 1171*171 equals H171+5 and to 'Jane' otherwise. 173 174 175 Logical Functions 176 In the yellow cell immediately below write a formula that sets the cell to 'Yes' if either 1171 or H171 equals 2 and to 'No' otherwise 177 178 In the yellow cell immediately below write a formula that sets the cell to 'Yes' if both 1171*J171 and H171+5 equals 6 and to 'No' otherwise. 179 180 181 Conditional Calculation Functions 182 Write a formula in the yellow cell immediately below the counts the values in Column H of the grey range that are equal to 'A'. А 1 184 B 2 185 3 186 Write a formula in the yellow cell immediately below the sums the values in Column H of the grey range that are equal to 'A'. 187 1 188 B 2 189 A 3 190 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. 191 The formula in B193 should use a 's' so that it can be copied down to B194. A 192 Copy cell 0193 down to cell 0194 B 193 A A 3 194 B A 4 195 B 5 196 IFERROR function 197 Write a formula using IFERROR in the yellow cell immediately below that results in a blank ("") when you divide H198 by 1198. 198 0 199 200 ISERROR function 201 Write a formula using ISERROR in the yellow cell immediately below that subtracts 1202 from H202 if dividing H198 by 1198 results in an error and adds them otherwise. 202 20 203 204 Write formulas that calculates the following for each scenario 205 Name Scenario 1 Scenario 2 Scenario 3 206 A 4 3 207 B 0 2 2 208 с 4 4 4 209 210 For each scenario if either A- or B-o are true cet the cell value to 1 otherwise to

Answer 1

Following are the answers :
Please note -
Row Number against formula required is specified to identify the question.

171.
=If(H171=2,"1","2")

173.
=If(I171*J171=H171+5,"Dick",Jane")

177.
=If(or(I171=2,H171=2),"Yes","No")

179.
=If(and(I171*J171=6,H171+5=6),"Yes","No")

183.
=Countif(H183:H185,"A")

187.
=Sumif(H187:H189,"A",I187:I189)

193.
=Sumif(H191:H195,$C$193,I191:I195)

194.
=Sumif(H191:H195,$C$194,I191:I195)

198.
=Iferror("",H198/I198)