Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Nested Mess

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    HELP!

    I'm not sure how to get 3 things into a nested statement.

    Here's the logic (mmmm?)

    IF G1 NOT "" AND I1 > 0 Then "PAY AGREED"
    OR IF I1 = ISERROR Then "Reject Copy"

    is this possible.
    I'm sure it is, but it's friday afternoon

    Thanks
    Matt

  2. #2
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think this is it

    =IF(G1<>"",IF(I1>0,"Pay Agreed",""),"notagreed")

    but without test data cant be sure

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    could you explain the syntax....

  4. #4
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if g1 is not equal to blank,then if i1 is greater than 0 "pay agreed" else pay not agreed (I think)

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,496
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    1 Thread(s)

    Default



    Your information is not complete; you can try the following.

    =IF(ISERROR(I1),"Reject Copy",IF(AND(G1<>"",I1>0),"Pay Agreed",""))

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks...I think I've got it now!
    Matt

  7. #7
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,034
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-05-03 07:34, mrowe wrote:
    HELP!

    I'm not sure how to get 3 things into a nested statement.

    Here's the logic (mmmm?)

    IF G1 NOT "" AND I1 > 0 Then "PAY AGREED"
    OR IF I1 = ISERROR Then "Reject Copy"

    is this possible.
    I'm sure it is, but it's friday afternoon
    [img]/board/images/smiles/icon_smile.gif[/img]
    Thanks
    Matt
    You need to specify the data type of I1 and G1 may possibly take on, in particular when you mention ISERROR wrt I1.

    Try this:

    =IF(LEN(G1),IF(ISNUMBER(I1),IF(I1,"PAY AGREED","I1 is 0: What Now?"),"Reject Copy"),"G1 is kind of blank: What Now?")



    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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