Notifications
Clear all
Topic starter
I am setting variable conditions within a cell to prompt me to "Re-Order" =IF(AND(H4<TODAY()+60,O4<1),"Re-Order",""),OR(K3<300),"Re-Order","")))
Please advise if there is a easier/better method.
Posted : 31/10/2018 11:11 am
Hi Michael
Try this. If either one of the two conditions are TRUE then re-order
=IF(OR(K3<300,AND(H4<TODAY()+60,O4<1)),"Re-Order","")
It is not a better/easier method but a shorter formula 
Hope this helps.
Sunny
Posted : 31/10/2018 7:19 pm
