product function
 

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?

product function
 

< 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

"Michael Crofford" wrote in message ...
| 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?
|

product function
 

A1 = drop down list
B1 = 10

=A1*B1

Is the same as:

=PRODUCT(A1,B1)

--
Biff
Microsoft Excel MVP


"Michael Crofford" wrote in message
...
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?