Forum Discussion

Hussein_Mohamed's avatar
Hussein_Mohamed
Copper Contributor
Jan 15, 2024
Solved

excel formula assist

Dears, Could you please assist regarding a formula to perform the result as i attached in a sample.   Thanks in advance
excel
mathetes's avatar
mathetes
Silver Contributor
Jan 15, 2024
You've had nearly 60 views and no replies until this one. I suspect that the reason for this lack of response is that--though your request may be perfectly clear to you--we can't read your mind. You'd be far more likely to get a response if you spelled out what you're trying to do, what the context is, what those results are meant to mean. Otherwise you're in effect asking us to reverse engineer, without knowing the context and, perhaps more important, without the invested interest.
Hussein_Mohamed's avatar
Hussein_Mohamed
Copper Contributor
Jan 15, 2024

mathetes 

sorry for the confusion i have made.

I would like a payment plan with the following details: The first payment percentage will be determined at the beginning of the sales contract. The second payment, after a three-month interval, will have a specified percentage. The remaining amount will be divided equally over the designated number of years (in assum sheet), with payments made quarterly. Please note that the down payment percentage will be applicable from the start of the sales contract until the end of the specified sales years. The months between each quarter will have a payment value of zero.

i will attach the source file contain the original formula that i need to modify.

 

Thanks in advance

Resources