Adding and multiplying

  • Thread starter Thread starter suroora
  • Start date Start date
S

suroora

I have Excel 2002. How do I add A1 + B1 * C1? When I put the formula in, it
mulitplied A1 by C1 and added B1.

Thanks,
Suroor
 
Your formula would multiply B1 and C1 and then add A1

You can put () arund the pair you want to calculate first like
= (A1+B1)*C1
or
= A1 + (B1*C1)
in this case not really needed
 
Thanks, Sheeloo! That worked.

Sheeloo said:
Your formula would multiply B1 and C1 and then add A1

You can put () arund the pair you want to calculate first like
= (A1+B1)*C1
or
= A1 + (B1*C1)
in this case not really needed
Click to expand...
 

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

Merging cells and formats 8
Multiple ifs and formulas 5
Nameing a function 1
SUMIF "value if false" not working 2
Excel functions 0
Countifs with different restrictions 1
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
if function, how? 4

Back
Top