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

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

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

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

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