Adding and multiplying

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
 
S

Sheeloo

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
 
S

suroora

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

If, Or, and 5
Merging cells and formats 8
Nameing a function 1
SUMIF "value if false" not working 2
Referencing the values of multiple cells in conditinal formatting. 0
Help with IF Function for times. 5
COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
Copying a cell value to another sheet by using If statement 1

Top