| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for multiplying and adding percentage please help. | New Users to Excel | |||
| Multiplying then adding Two Rows of Numbers | Excel Worksheet Functions | |||
| Multiplying non consecutive rows, than adding it. | Excel Discussion (Misc queries) | |||
| Multiplying non consecutive rows, then adding it. | Excel Worksheet Functions | |||
| Sumproduct multiplying instead of adding | Excel Worksheet Functions | |||
Linear Mode
