Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum Product Function Maybe | Excel Worksheet Functions | |||
product function | Excel Worksheet Functions | |||
product function | Excel Worksheet Functions | |||
product function | Excel Worksheet Functions | |||
product function | Excel Worksheet Functions |