IF statement based on values from another cell

Josh RT

Hello,

I am trying to add a 4th condition to my IF statement which already has 3 criteria.

My current working formula for 3 criteria is:

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

I am creating an inventory sheet where if "In stock qty" column is less than "Reorder level" than to return "REORDERED NEEDED" or if it is greater than reorder level than to put "OK". If there is a date filled out in the "reorder date" column that takes priority and outputs "Reordered"

The tricky part is adding in my 4th condition. If "In stock qty" drops within 500 or less of "Reorder level", I want it to output "Reorder soon" but if the "In stock qty" drops below "Reorder level", it needs to change back to "REORDERED NEEDED" again.

The formula I've been trying to use to add my 4th condition is:

=IF(ISDATE([Reorder date]@row), "Reordered", IF([In stock qty]@row <= [Reorder level]@row, "Reorder Needed", "OK", IF(AND([In stock qty]@row = < 500 [Reorder level]@row, "Reorder soon"))))

jessica.smith

Does this work as expected?

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

jessica.smith

Does this work as expected?

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