How do I write an IF statement and embed another IF statement

Question

The format of the IF statement is:

=IF(logical_test, value_if_true, value_if_false)

Example

=IF(A2 = "Pizza","Yes, Pizza","No")

Is cell A2 has Pizza, then it will return "Yes, Pizza" otherwise it will say "No"

To embed another IF statement within:

=IF(A2="Pizza",IF(B2="Cheese","Cheese Pizza","No"),"No")

If cell A2 has Pizza, then Excel checks to see if cell B2 has Cheese, then it will return "Cheese Pizza", otherwise it will say "No". If cell A2 does not have Pizza, it will return "No"

Answer 1

her IF statement

The format of the IF statement is:

=IF(logical_test, value_if_true, value_if_false)

Example

=IF(A2 = "Pizza","Yes, Pizza","No")

Is cell A2 has Pizza, then it will return "Yes, Pizza" otherwise it will say "No"

To embed another IF statement within:

=IF(A2="Pizza",IF(B2="Cheese","Cheese Pizza","No"),"No")

If cell A2 has Pizza, then Excel checks to see if cell B2 has Cheese, then it will return "Cheese Pizza", otherwise it will say "No". If cell A2 does not have Pizza, it will return "No"