Nested IFs?
Results 1 to 2 of 2

Thread: Nested IFs?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2019
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Nested IFs?

    Hi everyone

    I'm using the below code which works fine:

    Code:
    =IFERROR(IF(J29="As Required","Confirm Qty",J29*K29),)
    But I'm trying to work out how to add another if statement into the above code at the end so that the following also happens:

    If K29="Item Not Found" then ALSO in L29 print "Update List", otherwise J29*K29

    Does that make sense, please could someone give me a hand? I've tried using the IFS statement and I can't get it to work properly

    Thank you!

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,068
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Nested IFs?

    IF K29="Item Not found"

    This is text, you cant multiply text as in J29*K29
    You need to establish its not text FIRST.

    so, maybe

    =IFERROR(IF(J29="As Required","Confirm Qty",IF(K29="Item Not Found", "Update List", J29*K29)),)

Some videos you may like

User Tag List

Tags for this Thread

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
  •