View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Mikjall777 Mikjall777 is offline
external usenet poster
 
Posts: 3
Default Multiple functions in a cell help

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)

Hopefully this clears it up more. If not, I'll keep trying to explain in a
better way of what I'm looking for.

Thanks for the help!
Mike