G
gdmn6
I need a formula that multiplies within two separate cells. (IE: I need cell
G2 to equal H2x12 OR G2 to equal I2x52. Thanks
G2 to equal H2x12 OR G2 to equal I2x52. Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
Have you looked in the help index for OR?
G
gdmn6
Yes, and it returns a true not a sum.
Don Guillett said:Have you looked in the help index for OR?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
[email protected]
D
David Biddulph
What is the condition that determines which of the two answers you want?
G
Gord Dibben
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
Perhaps something like this..........
=IF(A1="OK",H2*12,I2*12)
Gord Dibben MS Excel MVP