| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas for multiplying cells
I need a formula that multiplies within two separate cells. (IE: I need cell
G2 to equal H2x12 OR G2 to equal I2x52. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas for multiplying cells
Have you looked in the help index for OR?
-- Don Guillett Microsoft MVP Excel SalesAid Software "gdmn6" wrote in message ... I need a formula that multiplies within two separate cells. (IE: I need cell G2 to equal H2x12 OR G2 to equal I2x52. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas for multiplying cells
Yes, and it returns a true not a sum.
"Don Guillett" wrote: Have you looked in the help index for OR? -- Don Guillett Microsoft MVP Excel SalesAid Software "gdmn6" wrote in message ... I need a formula that multiplies within two separate cells. (IE: I need cell G2 to equal H2x12 OR G2 to equal I2x52. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas for multiplying cells
What is the condition that determines which of the two answers you want?
-- David Biddulph "gdmn6" wrote in message ... I need a formula that multiplies within two separate cells. (IE: I need cell G2 to equal H2x12 OR G2 to equal I2x52. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formulas for multiplying cells
What determines which cell to multiply by 12 in G2?
Perhaps something like this.......... =IF(A1="OK",H2*12,I2*12) Gord Dibben MS Excel MVP On Wed, 21 Nov 2007 10:32:01 -0800, gdmn6 wrote: Yes, and it returns a true not a sum. "Don Guillett" wrote: Have you looked in the help index for OR? -- Don Guillett Microsoft MVP Excel SalesAid Software "gdmn6" wrote in message ... I need a formula that multiplies within two separate cells. (IE: I need cell G2 to equal H2x12 OR G2 to equal I2x52. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiplying cells and adding that answer in the same cell | Excel Discussion (Misc queries) | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| multiplying the same cell by different cells and copying formula | Excel Worksheet Functions | |||
| multiplying by blank cells input by "IF" functions | Excel Discussion (Misc queries) | |||
| Multiplying the contents of two cells a variable number of times | Excel Worksheet Functions | |||
Linear Mode
