+ Reply to Thread
Results 1 to 4 of 4

Nested IF statments

  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    2

    Nested IF statments

    I would like to do perform a nested if statement but seem to be doing it wrong.

    example:

    I am asking a question and would like either the answer be y or n. If the answer is not y or n the error message is displayed.

    question::

    Is the value given?(y/n)

    the user will have to input y or n in cell G8, so in H8 I try to include an if staetment:
    =IF(G8=y,"Please input the value below",IF(G8=n,"Please proceed with Step 1",IFERROR))

    Please send me in the right direction.

    Thanks.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Nested IF statments

    Hi RJK, welcome to the forum.

    The y and n should be within quotation marks, for example:

    =IF(G8="Y","Please input the value below",IF(G8="N","Please proceed with Step 1","Error"))

    Hope that helps!

  3. #3
    Registered User
    Join Date
    05-09-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Nested IF statments

    Works great!! Now how do I set it so that "Error" is not the default reply? How do I leave cell H8 blank until there is an input?

    Thanks again for the help!

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Nested IF statments

    Simply add another condition, e.g.

    =IF(G8="","",IF(G8="Y","Please input the value below",IF(G8="N","Please proceed with Step 1","Error")))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1