Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jan 2014
    Posts
    18
    Thanks
    13
    Thanked 0 Times in 0 Posts

    <Solved> help ADD "if" cell is blank do nothing

    I have a "IF" code that I need to add to.

    I would like to add, but if cell "I" (in the same row) contains the word "Scrap" then do nothing. Is it possible?

    Below is my original code and the screen layout.

    Thank you in advance for your help.



    =IF(TODAY()>F3,"Calibration Now",IF((TODAY()+14)>F3,"Expire Soon",""))

    Capture.JPG
    Last edited by timberwolf; 2014-03-21 at 13:33.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,635
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Is this what you are looking for?

    =IF(I3="Scrap", "", IF(TODAY()>F3,"Calibration Now",IF((TODAY()+14)>F3,"Expire Soon","")))

    Maud

  3. #3
    New Lounger
    Join Date
    Jan 2014
    Posts
    18
    Thanks
    13
    Thanked 0 Times in 0 Posts
    If I insert that code everything goes to "Expires soon" I have included a dummy file to look at

    Thank you




    Dummy.xls

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You have manual calcuation on the workbook. Turn on automatic calculation or press <F9> to recalculate the values.

    Steve
    PS you may want to use:
    =IF(trim(I3)="Scrap", "", IF(TODAY()>F3,"Calibration Now",IF((TODAY()+14)>F3,"Expire Soon","")))
    If you want to find the "Scraps" that have the extra spaces in them (as you have in row 5)...

    or even
    =IF(ISNUMBER(SEARCH("scrap",I3)),"", IF(TODAY()>F3,"Calibration Now",IF((TODAY()+14)>F3,"Expire Soon","")))
    if you meant containing scrap in any part of the contents of I3...
    Last edited by sdckapr; 2014-03-21 at 09:48.

  5. The Following User Says Thank You to sdckapr For This Useful Post:

    timberwolf (2014-03-21)

  6. #5
    New Lounger
    Join Date
    Jan 2014
    Posts
    18
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Thank you! that worked great. is there a way to add "retired" to the search? so if "scrap" or "retired" shows up it would work?

    =IF(ISNUMBER(SEARCH("scrap",I3)),"", IF(TODAY()>F3,"Calibration Now",IF((TODAY()+14)>F3,"Expire Soon","")))

  7. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,635
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Timberwolf,

    I added:

    =IF(I3="Scrap", "", IF(TODAY()>F3,"Calibration Now",IF((TODAY()+14)>F3,"Expire Soon","")))

    to cell G3 and copied down. It works fine. Note: in cell I5 you have "<space>Scrap<space>" instead of "Scrap"

    If you want to add "retired" then this will also work in G3 and copy down"
    =IF(OR(I3="Scrap",I3="retired"), "", IF(TODAY()>F3,"Calibration Now",IF((TODAY()+14)>F3,"Expire Soon","")))

    Maud

  8. The Following User Says Thank You to Maudibe For This Useful Post:

    timberwolf (2014-03-21)

  9. #7
    New Lounger
    Join Date
    Jan 2014
    Posts
    18
    Thanks
    13
    Thanked 0 Times in 0 Posts
    Thank you both for your quick response and your help. problem solved

Posting Permissions

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