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