Sorry abbut the layout - cut and paste - not very pretty here.

Premium Sum of Remaining Surrender
Premium Withdrawn Prem. W/D Assessed S.C. % Charge
10,399.43
10,100.00 10,100.00 10,100.00 299.43 0.075 757.5
100.00 100.00 10,200.00 199.43 0.08 8
100.00 100.00 10,300.00 99.43 0.08 8
100.00 99.43 10,399.43 - 0.08 7.9544
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0

What I'm looking for is to generate the total for the column of numbers
without all the intermediate steps.

1. I will have to generate the 10399.43. Once I have that as long as the
sum of the premiums (first column of numbers is less than the number that I
generated) take the first column of numbers * the fifth column of numbers.
When the sum of the premiums is greater than the number that I generate use
zero, except when it crosses over and use the 99.43 * .075

To get the grand total of 781.45 = 757.5 + 8 + 8 +7.95

2. Is there a way to do this without having to store all the intermediate
steps

Check this out please
http://www.savefile.com/files/211106

Regards

"Brad" wrote in message
...
Sorry abbut the layout - cut and paste - not very pretty here.

Premium Sum of Remaining Surrender
Premium Withdrawn Prem. W/D Assessed S.C. % Charge
10,399.43
10,100.00 10,100.00 10,100.00 299.43 0.075 757.5
100.00 100.00 10,200.00 199.43 0.08 8
100.00 100.00 10,300.00 99.43 0.08 8
100.00 99.43 10,399.43 - 0.08 7.9544
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0
100.00 - 10,399.43 - 0.08 0

What I'm looking for is to generate the total for the column of numbers
without all the intermediate steps.

1. I will have to generate the 10399.43. Once I have that as long as the
sum of the premiums (first column of numbers is less than the number that
I
generated) take the first column of numbers * the fifth column of numbers.
When the sum of the premiums is greater than the number that I generate
use
zero, except when it crosses over and use the 99.43 * .075

To get the grand total of 781.45 = 757.5 + 8 + 8 +7.95

2. Is there a way to do this without having to store all the intermediate
steps