Deductin one number with the given number and spreading the remainder in different columns

Dear Sir,
I have a problem, There is one number in D1 cell and it should be deducted another D2 cell number and the balance should be deducted again by the same D2 cell number and it should spread in the columns till it gets zero.

Ex: 50000 in D1 and 10000 in D2 IF i enter these two it should spread like E1 10000 F1 10000 G1 10000 H1 10000 equally till it gets zero

Regards,
Murali

In E1

Formula:

Please Login or Register  to view this content.

In F1

Formula:

Please Login or Register  to view this content.

copy F1 across

Dear Sir,
It is working, thank you, but I need to keep the E column as blank, instead give me solution like
Ex: if i enter D1 50000 in the main cell and the monthly deductible amount in E1 column the D1 Cell amount should be spread across the row till it get zero

Try this in F1:

=MIN($E$1,$D$1-SUM($E$1:E$1))

Thanks Sir,
It is working,
Regards,
Murali

Dear Sir,
This is working only for one row, if I copy the same to below rows it is not working. The $ marked cells I have changed based on the following row.
Please help me boss.

Originally Posted by krishco

Thanks Sir,
It is working,
Regards,
Murali

Isn't that the same that I gave which you said wasn't working?

Remove the dollar sign:

=MIN($E1,$D1-SUM($E1:E1))