=IF(SUM(E2:E2)=A2,0,IF(AND(SUM(C2:E2)<A2,SUM(C2:E2 )B2*3),B2*3,SUM(C2:E2)))

I think

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Candentco Creative Collection" <Candentco Creative
wrote in message
...
I am try to do the following: (i.e....)

Col A Col.B Col C. Col. D Col E col. F
$50,000 $2,000 $2500 $1,000 $5,000 ???


if the sum of columns c through e is less than col A and greater than Col.
B
times 3, then return col. b times 3. if not, return col a minus sum of
column c through one cell before Col f Also, if sum of c thru e is
greater
than or equal to col a, then reutrn 0