Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
The way you wrote it [=a1/4*(G19)], g19 was being mulitiplied by 4 and a1
was being divided by the result. You might want to look at this topic in Excel Help: About calculation operators Not true. A1 is divided by 4, then the result multiplied by G19. WRT precedence, as it says in Help, multiplication and division have the same priority and "if a formula contains both a multiplication and division operator — Excel evaluates the operators from left to right". He wrote =A1/4*(G19). That is the same as =A1/4*G19, which evaluates as I described above. If that's what's wanted, no parentheses are required. Parentheses are needed only if you want to do what you have described, but the the formula for that would be =A1/(4*G19), with the 4 inside the parentheses. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) |