| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula's
You need to add (): Excel divides and multiplies before it adds and substracts.
(A1+A2)/10 -- Excel will 1st add then divide the result of the addition. "TDF" wrote: when i add 2 numbers then divide by a number it's answer is wrong, why example: when i add 500 = A1 100 = A2 =A1 + A2/10 answer comes back as 150 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Formula's | Excel Worksheet Functions | |||
| Help in Excel creating Formula's | Excel Worksheet Functions | |||
| Comparing formula's of 2 excel workbooks | Excel Discussion (Misc queries) | |||
| Excel Formula's | Excel Worksheet Functions | |||
| Excel Formula's | Excel Worksheet Functions | |||
Threaded Mode
