#1   Report Post  
Myrna Larson
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I isolate my Excel server (automation) from other Excel instances? Joseph Geretz Excel Discussion (Misc queries) 5 July 19th 13 03:18 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM
VB Automation is Whacking out my Excel Environment Joseph Geretz Excel Discussion (Misc queries) 2 December 29th 04 03:49 PM


All times are GMT +1. The time now is 02:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"