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?
|