need help with excel formula to calculate based on cumulative

Hi guys,

I am hoping someone can help with an excel formula. I have the following example:

if sum of records is under 1000 then multiple by 5%. If cumulative of values goes over 1000, it needs to multiply by 10.

On row 3 below, the sum of 200+300+550 = 1050. So, I need a formula to split the 550 into 500*.05 and 50*.10 so the result will come up as 30.

1)200, result 10
2)300, result 15
3)550, result 30
4)400, result 40
5)600, result 60

Any easy way of doing this?

Hi !

As here it is the VBA forum, any VBA question ?

No, so ask a moderator to move this thread to the appropriate Excel forum !