Question: Can someone help me determine how to syntax the nested if function. Thanks! In the Logical Functions worksheet, enter the text Enter a date in
In the "Logical Functions" worksheet, enter the text "Enter a date" in cell C5. Highlight cell DS in yellow and enter any valid date. In cell C6 enter the text "This is the name of the month:" In cell D6, entered in cell D5. Resize columns C and D to fit the largest item in each respective column. Hint: you can use the month(date) function to return a value between 1 and 12 depending on the month in date. enter a nested if function to calculate and display the name of the month from the date
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
