Thanks for taking the time to teach me how to drive! .. sorry for being such
a neophite.



"Ron Rosenfeld" wrote:

On Tue, 12 Aug 2008 02:58:10 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:


The thing that gets me is the OP posted at least 3 different tier pricing
examples and, in each of them, his totals did not calculate correctly (or at
least they did not calculate to what I am sure they should have). I finally
got him to agree to what I am sure is the correct way to use his tier
structure and posted the formula for him (which he attempted to generalize
and missed a term in the process). So yes, hopefully he will get this all
straightened out before too long.

Rick

Well, the VLOOKUP and table method I posted does seem to work correctly on his
various examples. On most of them, he used a straight $0.40 for each tier. And
once he has the table set up, to change the tier pricing he only needs to
change the values in column 3; to change the tiers, he only needs to change the
lowest value in each tier in column 1. And to change the number of tiers, he
only needs to extend the table.

He does have to set up the table correctly in the first place, though.
--ron