Hey,
Does anyone know a formula to use for the following?
excel2.jpg
Rows are either 'a' or 'b' classifications and column F shows the running balance for each. I want to multiply the running balance by the weighted average rate. Example is cell H4 should be (200,000/2,200,000*7%)+(2,000,000/2,200,000*12%). Is there a formula for this? I also only want to include the current row and all rows above in the calculation. The calculation should not include any rows below, therefore the rows are also classified by numbers in column A. I was thinking a SUMPRODUCT function may work so I can multiply column E times column D but I would need to divide each product by the amount in column F only in the current row. I would also set some sort of IF function to that column A is less than or equal to the current value for column A AND column B = either a or b.
Pretty complex formula I think. DOES IT EXIST???
Thanks in advance for help.
Bookmarks