Can someone help me determine how to syntax the nested if function. Thanks! In t

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 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

Explanation / Answer

In excel IF is an in-built function also known as logical function we can write upto 7 IF functions to create a complex if then else statement.

if you use excel latest 2016 we have IFS function which you can directly use without any nested if statements.

The syntax for nested if is

IF( condition1, valueiftrue1, IF( condition2, valueiftrue2, valueiffalse2 ))

here is the syntax of nested if ,where we can add upto 7 if's.

If the condition1 is true it gives the output value true1 or else then it goes to next if there also same it checks condition 2 and is true gives ouptut true2 value.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.