Formulas for multiplying cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula that multiplies within two separate cells. (IE: I need cell
G2 to equal H2x12 OR G2 to equal I2x52. Thanks
 
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
(e-mail address removed)
Click to expand...
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CountIf with And 0
Finding location (or start cell) of highest consecutive values 3
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Formula Help 3
Help getting 2 formulas into one 2
IF AND statements 6
Conditional Format 1
Conditional Formatting 4th Condition 3

Back
Top