Nested Formula

Vinton Douglas

Hello Smartees,

I have the following formula pulled from some columns. The focus is on the "Reorder Status"

The Reorder Status is displaying "OK" even when the "Minimum Par Level/Reorder Level" and/or the Max Par level are blanked. I want the formula to display "Par Level Entry Error(s)" if both par levels or one of the par levels is blank. If "Current Stock Quantity Total" is blank, I want the "Reorder Status" to be Blank

Any help would be grateful

Kelly Moore

Hey @Vinton Douglas

Here you go

=IF(OR([Minimum Par Level/Reorder Level]@row = "", [Max Par level]@row = ""), "", IF([Current Stock Quantity Total]@row > [Max Par level]@row, "OVERSTOCKED", IF([Current Stock Quantity Total]@row < [Minimum Par Level/Reorder Level]@row, "REORDER NEEDED", "OK")))

Does this work for you?

Kelly

Vinton Douglas

Hi Kelly,

Thanks so much. This is is working very good. Would you be able to tweak the formulla so that it displays "Par Level Entry Error(s)" if both par levels or one of the par levels is blank?

Vinton Douglas

Kelly Moore

Hey Vinton

Oops, sorry. I forgot you had asked for that. To tweak the formula, we just need to replace the response of blank, as I have it currently directed in your formula. You can fill in whatever you desire between the two quote marks. I also added the blank if the Current Stock Quantity is blank.

=IF(OR([Minimum Par Level/Reorder Level]@row = "", [Max Par level]@row = ""), "Par Level Entry Error(s)", IF([Current Stock Quantity Total]@row="", "", IF([Current Stock Quantity Total]@row > [Max Par level]@row, "OVERSTOCKED", IF([Current Stock Quantity Total]@row < [Minimum Par Level/Reorder Level]@row, "REORDER NEEDED", "OK"))))

Kelly