Here is a shot

=IF(A1*2>10,A1*10,A1*2)

it doesn't work for the 7 in your example, but that one doesn't seem to
correspond to your description.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ATK" <ATK.1wwdmd_1129302311.972@excelforum-nospam.com> wrote in message
news:ATK.1wwdmd_1129302311.972@excelforum-nospam.com...
>
> 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.
>
>
> --
> ATK
> ------------------------------------------------------------------------
> ATK's Profile:
http://www.excelforum.com/member.php...o&userid=27662
> View this thread: http://www.excelforum.com/showthread...hreadid=476252
>