Multiply by this if this ... help!

  • Thread starter Thread starter kmyers
  • Start date Start date
K

kmyers

I have a very difficult formula to create ...
see example below:

If this field is___20 multiply "A" by Column I
40 multiply "A" by Column II
60 multiply "A" by column III
I II III
20 40 60 Sum

"A" 2 3 4 ______

If this isn't clear ... I can try again if someone has an answer ...
Thank you!!

:confused:
 
B4 could be 20,40 or 60
B8 could be any # - multiplies by D8, E8 or F8 with D being 20, E being
40 and F being 60
the numbers in D8 through F8 are 2 , 3, and 4.

the sum ending up in O8. Whew! I am trying not to get scrammbled.
What would the foprnula be for that cell? Once i get that in I can
figure out the rest.
 
Thank you ... I am still not getting it right.
I need to multiply B8

IF C4 is 1 by C8 by - IF C4 is 12 by F8 - IF C4 is 36 by I8 - IF C4
is 60 by L8

(these are the actual numbers and cells. I am not really familiar with
the IF or CHOOSE funtions. Maybe that's why I am confused.:confused:
:confused: :confused:
 
I'm confused now, too...

In previous posts, you mentioned 20, 40, and 60 as being your
conditions, in this one you say 1, 13, 36, and 60.

I think you need to rewrite your question, and instead of using
specific numeric examples, explain the general process you'd use to
explain to someone how to get the results you want (someone who
can't see all your specific data). If you're confused, the odds that
someone will be able to guess what you want are pretty slim.
 
Back
Top