PDA

View Full Version : Solved: Sumproduct problem in table



tlchan
01-10-2009, 09:12 PM
I used one of the sumproduct function from the forum to calculate the total fee charged on a loan based on various level of scale fee shown in the worksheet.

Basically what I want is user to input loan value in cell A7 and related fees and stampt duty will be calculated in cell D7,D8 and D10.

Cell D7 and D8 are working fine but I have problem to get the value in cell D10 shown as #Value!.

Can anyone assist,please.

Bob Phillips
01-11-2009, 04:48 AM
D8 looks fine to me.

D10 just needs changing to

= SUMPRODUCT(--(A7>{0,150000,850000,2850000,4850000}),A7-{0,150000,850000,2850000,4850000},{0.01,-0.003,-0.001,-0.001,-0.001})

tlchan
01-12-2009, 07:27 AM
Thanks Xld, your solution works great.

However I make slight changes to =SUMPRODUCT(--(A7>{0,150000,1000000,3000000,5000000}),A7-{0,150000,1000000,3000000,5000000},{0.01,-0.003,-0.001,-0.001,-0.001}) to get the expected result.


Thanks again :beerchug: