06-17-2020 08:10 AM
06-17-2020 08:10 AM
06-18-2020 08:16 AM - edited 06-18-2020 08:18 AM
You've had a fair number of views but no replies to date. I suspect that people are passing for the same reason: your request is too vague.
Is it possible for you to spell out some rules for the situation you're describing. You give a couple instances, but no framework for actually constructing the formula. So here are some questions for you to answer that might start pointing a potential helper in the right direction.
It's entirely possible that if you define your situation more clearly you will be able to write the formula (or formulas) yourself.
But the main point: the more clearly and precisely you can describe the situation, the more clearly and precisely somebody else can resolve it.
06-18-2020 09:40 AM - edited 06-18-2020 09:46 AM
Hello @mathetes and thanks for reply.
I'm really sorry for vague request.
I'm creator of invoice, and i want to send mail to customer if he is late with payment.
For example: i sell TV to customer and i give him to pay that TV for 5 months with equal installments, and there is no interest charged.
I know how to calculate without installments with today, if(and)...but i need formula for aging when i have information like in picture below with installment amount and number of installments, and all that in one row, without making rows as much as i have number of installments.
06-18-2020 10:20 AM
Is it possible for you to post the actual spreadsheet (with dummy names such as you did in that image)?
And if I may ask yet another question or two, now that I know you are generating the invoice based on your spreadsheet:
At one point my wife was doing consulting with a couple organizations, and we had to prepare monthly invoices for her clients. I created a database into which she entered hours worked each day and some brief description of the nature of the work, so that we could generate an itemized invoice. All this from within Excel.
Your need is different in some ways, but also similar in some ways. What you've shown me is just one row of a spreadsheet; I'd be interested in what the rest of it looks like, whether you're making optimal use of Excel--for tracking the history of a customer's account over time--or just using it to do some relatively simple calculations growing out of a single transaction.