Forum Discussion
Solved
Quarterly split of revenue
Hi, I am looking for a formula where I can split my quarterly revenue in to equal amounts so as to get monthly income. For example: I am getting a monthly amount of $300 from Mr. A and a qua...
Hi,
You have to use two formulas, the start formula is this:
=$D2/$E2
And you have to insert it in the very first month for each row.
This is the second formula and will depend on the first one:
=IF(G2=0,0,IF(COLUMN(B1)<=$E2,
$D2/$E2,
($D2/$E2)-G2))
Please insert it in the second month and drag it to the right and down.
Please see the attached file.
Regards
Thank you so much for your help!