Quote Originally Posted by shg View Post
Can you explain your example results?
Argh. The numbers changed when I pasted it to a new spreadsheet for some reason. The total number was originally 390,000. But using $400,000 as in the example, it SHOULD have values of $9,000 and $21,000 in the following rows of the first column.

With a base number of 400,000 records, I apply a rate of $0.00 to the first 10,000 records. Then for records 10,001 to 100,000 a rate of $0.10 is applied (90,000 x $0.10=$9,000), and the remaining 300,000 records are at a rate of $0.07 or $21,000 for a grand total of $30,000

Sorry for the confusion.