Do you mean that you want 4*2.43 + 5*2.43 + 6*2.43 + 7*2.43 + 8*2.43 +
9*2.43 + 10*2.43 + 11*1.75 + 12*1.75 +13*1.75 etc up to 61*1.75 ? (and
whatever for ?) Or, could it be that you want (10-4)*2.43 +
(61-11)*1.75 ?

Please explain.

Pete

On Jul 22, 10:53*am, LindaM wrote:
I am trying to write a formula that will multiple the numbers between 4 and
10 by $2.43 and add that to the numbers between 11 and 100 that is multiplied
by $1.75.
Example: A1 = 61 and the total in B1 would be 4 thru 10 multilplied by 2.43
and then added to 11 thru 61 that has been multiplied by 1.75
--
LindaM