IF state with 3 sets of criteria

Josh RT

Hello,

I am struggling to get my IF formula to give me anything other than #UNPARSEABLE

I am creating an inventory sheet where if "Stock qty" column is less than "Reorder level" qty than to return "REORDERED NEEDED" or if it is greater than reorder level than to put "OK" but the tricky part comes when I add in my third criteria.

If there is a date filled out in the "reorder date" column then I want that to take priority and output "Reordered"

Any help on writing this formula would be greatly appreciated as I've been at it for days with no luck.

jessica.smith

Try this formula:

=IF(ISDATE([Reorder date]@row), "Reordered", IF([Stock qty]@row <= [Reorder level]@row, "Reorder Needed", "OK"))

jessica.smith

Try this formula:

=IF(ISDATE([Reorder date]@row), "Reordered", IF([Stock qty]@row <= [Reorder level]@row, "Reorder Needed", "OK"))

Josh RT

Thank you! This worked perfectly. I really appreciate your help