Last seen: Jul 7, 2026
I'm OK on your first comment. That's what I've been trying to explain all the time. So, just use the formula I suggested. Your second comment, howe...
I'll do my best but can't guarantee I fully understand. The early settlement amount should be calculated only if you repay no later than the 22nd d...
So much for AI. Sometimes it works, sometimes not.
Does the attached file work for you? If not, which Excel version are you working with?
That i understand, but not the calculations you made initially. If you would do the analysis manually (with pen on paper) what would be the outcome y...
Not sure I got it right but perhaps the attached workbook contains the solution you need. I added a column that determines if the row is visible (1) o...
Can't tell I really understand your schedule then. The interest earned for the month at 6% for the number days you held on to an investment would be: ...
Well that formula seems to calculate an amount relative to the actual number of 'early days' at 6%, irrespective of the timing of the early payment. I...
Your current formula calculates the discount based on the number of early days, wether or not early payment occurred on or before the 22nd of the mont...
Please see attached. It's no more than unpivot, merge columns, sort and transpose 🙂
No file was attached. Please try again and don't forget to press 'Start upload' before you submit your reply.
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Let's start from scratch on a clean file and with a slightly different approach. I've attached 4 files demonstration each step. Step 1: Connect to ...
Could you upload a file as you download it from the web site? Difficult to help otherwise.
Perhaps not the most elegant solution but you could simply use COUNTIF as demonstrated in the attached example.