product function

  • Thread starter Thread starter Michael Crofford
  • Start date Start date
M

Michael Crofford

How can I put a formula in a cell that will give me a multiplication result
with a variable criteria.In other words I have a product function in 1 cell
then I have a list of constants and I want the sum to be varied by a choice
from a dropdown in another cell what would the syntax be?
 
< I want the sum to be varied >

The sum of what?

Can you give an example?
Of all the cells involved? their values, their formulas?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| How can I put a formula in a cell that will give me a multiplication result
| with a variable criteria.In other words I have a product function in 1 cell
| then I have a list of constants and I want the sum to be varied by a choice
| from a dropdown in another cell what would the syntax be?
|
 
A1 = drop down list
B1 = 10

=A1*B1

Is the same as:

=PRODUCT(A1,B1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Totalling seperate cells from a HLOOKUP function 8
Excel VBA 1
Help With MS Access 4
Mapping integers to strings 5
INDEX return multiple columns 1
will a function do this for me? 1
Looking up a value in a list & returning multiple corresponding va 1
Sum all Values in a changing Column 15

Back
Top