| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Simple arithmetic
On Mon, 24 Jan 2005 17:35:21 -0000, "Pat" wrote:
Is the formula wrong or am I wrong? The formula is doing what it should do according to Excel's rules of precedence. The SUM function is superfluous. In order to obtain the result you posted, you need to rearrange your parentheses to match the order of calculation precedence in your (manual) calculation: =(AR32*AU32+AR32)/1.4+(AS32*AU32+AS32) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Excel user needs help with simple Macro... | New Users to Excel | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
| A simple maco . . . | New Users to Excel | |||
| Simple, Monday morning brain function | Excel Worksheet Functions | |||
Threaded Mode
