View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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