Hello, I'm trying to work on a calculator that will lookup values and change as the value grows. For example:
If I have something like this:
Our Rate table may look like:
0 .1
15 .2
25 .3
100 should be sum of 1* Rate Lookup all the way to 100 * Rate Lookup
200 should be sum of 101* Rate Lookup all the way to 200 * Rate Lookup
300 should be sum of 201* Rate Lookup all the way to 300 * Rate Lookup
When sum of value gets to RateNumber it should use next
If I have something like this:
Our Rate table may look like:
0 .1
15 .2
25 .3
100 should be sum of 1* Rate Lookup all the way to 100 * Rate Lookup
200 should be sum of 101* Rate Lookup all the way to 200 * Rate Lookup
300 should be sum of 201* Rate Lookup all the way to 300 * Rate Lookup
When sum of value gets to RateNumber it should use next