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 is the condition that determines which of the two answers you want?
 
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
 
You must log in or register to reply here.

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