Nested formula - in a muddle!

[MrsH]

I'm quite new to Excel (MO2010) and in a muddle with a nested formula - we rushed over this is my training course.

I want to do this in one cell:

if B4=0, enter "No", if B4=3, enter "Part", if B4=5, enter "Yes".

I've followed some of the previous examples on this site but get error messages that I can't resolve. Should the cells be set to General format for a mix of number and text to work?

Many thanks

 

[VoG]

Try

=IF(B4=0,"No",IF(B4=3,"Part",IF(B4=5,"Yes","")))

 

[Aladin Akyurek]

I'm quite new to Excel (MO2010) and in a muddle with a nested formula - we rushed over this is my training course.

I want to do this in one cell:

if B4=0, enter "No", if B4=3, enter "Part", if B4=5, enter "Yes".

I've followed some of the previous examples on this site but get error messages that I can't resolve. Should the cells be set to General format for a mix of number and text to work?

Many thanks

Structured...

=IF(B4="",
      "",
      IF(B4=0,
          "No",
          IF(B4=3,
              "Part",
              IF(B4=5,
                  "Yes",
                  ""))))

Unstructured...

=IF(B4="", "",IF(B4=0,"No",IF(B4=3,"Part",IF(B4=5,"Yes",""))))

 

[MrsH]

Thank you for the very helpful and rapid responses. It seems my error was in the bracket placement. Noted for future reference.

Thanks