Hi

Your description doesn't match your example.
Going by the example, I guess you multiply by 2 for any value up to and
equal to 5,
any value between 6 and 9, is 6*10 plus (Value-6)*2 and any value of 10
and higher multiply by 10.
If so
=IF(A1=10,A1*10,IF(A1=6,(6*10+(A1-6)*2),A1*2))

Regards

Roger Govier



ATK wrote:

I am looking for a formula that will allow me to apply one multiplier up
to a certain sum and then a different multiplier after it hits that
limit.

For example, I have a column of numbers 1, 3, 5, 7, 10. For the sum of
the numbers until 10, I need to apply a multiplier of 2. All sums after
10, I need to apply a multiplier of 10.

In this case, I would like the responding column to read 2 (2*1),
6(2*3), 10(2*5), 62(2*1+6*10), 100 (10*10)

Thanks.