On Mar 15, 3:29 pm, Ron Rosenfeld wrote:

Thanks for the input. Maybe I didn't fully set out the issue. The
State sets rates from zero to 100,000. Premiums are 229 up to and
including 10,000; 233 up to and including 10,500, and so on to 833 for
up to and including 100,000. This means I have 180 entries in the
column of policy amounts and the same number of premium amounts. I
tried to set up the formula for policy amounts exactly matching the
180 breaks set by the state and everything else in between. If my
formula had to deal with multiples of 500 and everything else, there
would be ten million iterations. That's what I'm trying to avoid.