Hi,
Im sure there is an easy way to do this, but having some trouble.
Say I have 5 colums
A1 - is a date
A2 - Is an order qty
A3 - Is a reserve qty
A4 - Is a Y or N value
A5 - is where I need my results
I need a function (Im assuming an =IF function, with maybe an AND function??)
That basically checks the date, and if the date is out 3 weeks from the current date AND order qty = reserve qty, AND A4 has a "Y" then I need A5 to read "OK"
if it doesn't meet those requirements I would need it to at least say "Look at"
(would be great if I could determine what the reason for not meeting the requirements is, so basically if the date fell within 3 weeks, it would say "Close" or "Date", and if the qty's don't match it could say "Qty" or "Short", and if it had an "N" value it would say "ASAP Order")
But that last [part is not necessary, as long as I can determine whether it meets all requirements, or not.
Thanks!
-Z
Bookmarks