Here is a shot

=IF(A1*210,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" wrote in message
...

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