[solved] – Question 71915

I would just like step to step answers to these questions.

6Use a nested MATCH function within the INDEX function in cell C40 to identify the date for the lowest temperature. Ungroup the worksheets.
8.000

11Enter 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
12Enter 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.

Expert Answer

---