If date <= today or cell value <= other cell value, then return text

[Unwyred]

I've made a spreadsheet to track a chemical inventory and am trying to get a cell to return the text, "1 bottle" if either the expiration date in cell H17 is less than or equal to today or the number of items in the quantity cell (D17) is less than or equal to that of the order point cell (C17).

I can get the formula to work if I just do it for the quantity<order point with: =IF(D17="","",IF(D17<=C17,"1 Bottle","")), but I want it to trigger the "1 bottle" text if the expiration date passes as well.

Have not been able to find anything close to this in any forum so far.

 

[6StringJazzer]

Update your formula to:

=IF(D17="","",IF(OR(D17<=C17,H17<=TODAY()),"1 Bottle",""))

BTW thanks for a very clear description of your problem.

 

[Unwyred]

Update your formula to:

=IF(D17="","",IF(OR(D17<=C17,H17<=TODAY()),"1 Bottle",""))

BTW thanks for a very clear description of your problem.

Works like a charm, thank you so much for the quick reply as well. I was sitting here for 2 hours racking my brain before I signed up to make a post here.

 

[kvsrinivasamurthy]

Try

=IF(OR(D17="",H17>TODAY()),"",IF(OR(D17<=C17,H17<=TODAY()),"1 Bottle",""))