I am trying to create a basic sheet for tracking orders, fulfilment and balance chasing but I am struggling with what should be pretty simple IF formula.
In the attached document I need cell O3 to give an answer if we need to chase the customer for the balance or not, it need to have multiple TRUE options also, this is the best way I can describe it:
IF L3 = YES and J3 is more than £0 then the TRUE value with either be IF C3 is old than TODAY - 22 days then put "Call customer to Chase" but if the date in C3 is older then 50 days from TODAY then put "Send 1st Letter" but if C3 is older than 80 days from TODAY then put "Send 2nd Letter". All the FALSE values would be "No Action"
I have tried a very basic IF that I understand in P3 but that is as far as my skills will let me go!
Thanks in advance
Andy
Bookmarks