Need formula(s) or macro to allocate cash receipts over previous customer debts

[Vasim]

Hi.

I have a huge data in excel like the one in the image link below:

Sample.jpg

I need to know which part of the receipt 450.00 (cell C8) belongs to D3, D4, D5 cells and etc. beginning from the first non-zero cell in D column, so that to find currency difference effect within 450.00 (C8) like the following: (200.00)*(1.80-1.98)+(450.00-200.00)*(1.86-1.98) or if we have 50.00 instead of 450.00 just to make calculation like this: (50.00)*(1.80-1.98).

I just can't imagine how to do it using formulas and I don't know VBA. So it is very much appreciated if anyone can help me with this issue either via excel formulas or macro.

[avk]

Try with In "F8" :

Please Login or Register  to view this content.

[Vasim]

Sorry, but I did not understand what this formula does, it returns zero.

[Vasim]

Try with In "F8" :

Please Login or Register  to view this content.

Sorry, but I did not understand what this formula does, it returns zero.