ExcelBanter - Adding and multiplying

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding and multiplying (https://www.excelbanter.com/excel-worksheet-functions/224601-adding-multiplying.html)

suroora

Adding and multiplying

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

Sheeloo[_4_]

Adding and multiplying

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

"suroora" wrote:

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

suroora

Adding and multiplying

Thanks, Sheeloo! That worked.

"Sheeloo" wrote:

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

"suroora" wrote:

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

All times are GMT +1. The time now is 02:04 PM.