Answer to Question #71915 in Excel for Thomas Taylor
6 Use a nested MATCH function within the INDEX function in cell C40 to identify the date for the lowest temperature. Ungroup the worksheets.
11 Enter a nested IF function in cell C6 to determine which city had the highest temperature. Based on the result returned in B6, enter the city name as OKC or Tulsa or Lawton in C6. Remember to enclose city names in double quotation marks in the function. Use Help if needed to help you understand a nested IF statement. Copy the formula down the High-City column. 6.000
12 Enter a nested IF function in cell E6 to determine which city had the lowest temperature. Based on the result returned in D6, enter the city name as OKC or Tulsa or Lawton in E6. Copy the function down the Low-City column.
Need a fast expert's response?Submit order
and get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!