1. <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.

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

Capture.JPG

2. Is this what you are looking for?

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

Maud

3. If I insert that code everything goes to "Expires soon" I have included a dummy file to look at

Thank you

Dummy.xls

4. 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...

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

timberwolf (2014-03-21)

6. 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. Timberwolf,

=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. 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
•