Mikjall777 wrote:
Mark,

I actually want the formula in cell g. Cells a through f should actually be
an inserted value and NOT inserted value with the math (that should be part
of the formula for cell g). Cell g should have some type of formula (without
any inserted values) that will function something like the following:

(inserted value of cell a*10) + (inserted value of cell b*2) +
(inserted value of cell c) + (inserted value of cell d*5) + (inserted value
of cell e*3) + (if (inserted value of cell f/20) < =10 then add 5 OR if
(inserted value of cell f/20) = 11 but <=20 then don't add anything OR if
(inserted value of cell f/20 =21 but <= 30 then subtract 5)

That makes much more sense, here goes...

Assuming that your data resides in Cells A1:F1

Enter the following formula into G1:

=SUM(A1*10,B1*2,C1,D1*5,E1*3)+IF(F1/20<=10,F1+5,IF(AND(F1/20=11,F1/20<=20),F1,IF(AND(F1/20=21,F1/20<=30),F1-5,F1)))

I hope that works as I doubt you are going to reply tonight and it will
be some time before I am on the net again.

Best wishes....