C
Crash Test Dummy
I am using Excel (Office 97).
I am having problems with order of operations. Here are some examples that
are self-explanatory. Each of the examples represent formulas in cells and
the result is listed after the = sign.
34.75/90*3.141593=1.213003964
(34.75/90*3.141593)=1.213003964
COS(34.75/90*3.141593)=0.350207256 This one is wrong if the calculation
is performed in the () in order from left to right.
COS(34.75/(90*3.141593))=0.992456932 Here you can see the only way to get
the same result as other programs or using any calculator (even the Windows
calculator in Accessories) is by adding an extra set of ()'s.
I am concerned about all of the formulas in Excel that users believe the
order of operations is being correctly performed.
Please comment if you feel I am in error or this is a problem (documented
or not).
I am having problems with order of operations. Here are some examples that
are self-explanatory. Each of the examples represent formulas in cells and
the result is listed after the = sign.
34.75/90*3.141593=1.213003964
(34.75/90*3.141593)=1.213003964
COS(34.75/90*3.141593)=0.350207256 This one is wrong if the calculation
is performed in the () in order from left to right.
COS(34.75/(90*3.141593))=0.992456932 Here you can see the only way to get
the same result as other programs or using any calculator (even the Windows
calculator in Accessories) is by adding an extra set of ()'s.
I am concerned about all of the formulas in Excel that users believe the
order of operations is being correctly performed.
Please comment if you feel I am in error or this is a problem (documented
or not).