samlee1981
New Member
- Joined
- Feb 12, 2019
- Messages
- 7
Hi,
I want to create a formula for a spreadsheet at work and i'm a complete ludite, so need help!
My dilema is the following;
When an invoice is 15 days before todays date, I want to create a formula to say it has become overdue. I have done this by making an IF statement. IF(D11-15< p$3,"overdue","not due")
This has returned an entire column with overdue and not due, according to todays date.
However, I now need another layer to it....
When payment is received, it is marked in the next column along. When paid, I want the 'overdue' from the original IF statement to go blank. How do I write and IF/OR statement incorporating countblank?
Not sure if i've made much sense but I basically want to say. If invoice is not paid before 15 days before todays date, state 'over due.' When paid (according to next column along) I no longer want overdue, I want it to be blank.
thanks!!
I want to create a formula for a spreadsheet at work and i'm a complete ludite, so need help!
My dilema is the following;
When an invoice is 15 days before todays date, I want to create a formula to say it has become overdue. I have done this by making an IF statement. IF(D11-15< p$3,"overdue","not due")
This has returned an entire column with overdue and not due, according to todays date.
However, I now need another layer to it....
When payment is received, it is marked in the next column along. When paid, I want the 'overdue' from the original IF statement to go blank. How do I write and IF/OR statement incorporating countblank?
Not sure if i've made much sense but I basically want to say. If invoice is not paid before 15 days before todays date, state 'over due.' When paid (according to next column along) I no longer want overdue, I want it to be blank.
thanks!!
Last edited by a moderator: