Simple math question
-
- cheese lizard
- Posts: 6241
- Joined: 16 Jan 2010, 00:14
- Location: Sydney Australia
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Simple math question
Spoiler
3÷1/3=9
9-9=0
0+1=1
=======
1
9-9=0
0+1=1
=======
1
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- PlatinumLounger
- Posts: 5420
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Re: Simple math question
One agrees with Rudi!
John Gray
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...
-
- cheese lizard
- Posts: 6241
- Joined: 16 Jan 2010, 00:14
- Location: Sydney Australia
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Simple math question
Without math order one might get three.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- Administrator
- Posts: 12629
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Simple math question
If one follows the basic rules of mathematics then one achieves the same result as Rudi. If one were to incorrectly understand the order of precedence of mathematical operators then one might indeed derive an incorrect result.
StuartR
-
- Administrator
- Posts: 78625
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Simple math question
In Excel, however, you have to write 1/3 as (1/3): the formula =9-3/(1/3)+1 returns 1, but =9-3/1/3+1 returns 9, since Excel doesn't distinguish between ÷ and /
Best wishes,
Hans
Hans
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Simple math question
And for interest sake (while on the topic of fractions), you can type proper fractions into a cell by preceding it with a zero and a space.
If you write 1/3 into a cell, Excel interprets it as a date.
If you write 0 1/3 into a cell, it is converted into a decimal number representing that fractions value
Although it does not make sense to type the expression like this...
=9-3/0 1/3+1
...it still works as Excel translates the proper fraction into a decimal when you press ENTER, and before the expression is evaluated.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 5StarLounger
- Posts: 1106
- Joined: 21 Jan 2011, 16:51
- Location: Florida
Re: Simple math question
Rudi,
Thanks for the "0 space" entry trick for fractions!
I'm often trying to put 32nds or 64ths into formula and this works very nicely!
Thanks for the "0 space" entry trick for fractions!
I'm often trying to put 32nds or 64ths into formula and this works very nicely!
PJ in (usually sunny) FL