Results 1 to 13 of 13
Thread: Windows calculator vs Excel
Hybrid View
-
06-13-2006, 08:59 AM #1
Windows calculator vs Excel
Here's an odd one, and I think shows calc.exe is faulty and not to be trusted.
Take two values:
2829.00 and 108.125%
Divide the first by the second in both programs.
Excel gives 2616.416 [=A2/B2%]
Calc gives 3058.85625
Checking the calculation shows the number calc is returning is actually the first value multiplied instead of divided by the percentage. Deliberately choosing either divide or multiply in calc shows exactly the same result on two different systems here.
Still relying on calc to manage your figures?Your one stop shop for decentralization
-
06-13-2006, 10:28 AM #2Web Hosting Master
- Join Date
- Feb 2003
- Location
- AR
- Posts
- 2,382
Calc gave me 2616.416
Kevin
(2829.00/1.08125)
-
06-13-2006, 11:14 AM #3
Hmm...if I leave off the % at the end, the number is still wrong. It gives 26.164....
How did you arrive at using that value: 1.08125?
Math is obviously not my strong point, and this is puzzling me.Your one stop shop for decentralization
-
06-13-2006, 11:16 AM #4Web Hosting Master
- Join Date
- Feb 2003
- Location
- AR
- Posts
- 2,382
108.125% is equivalent to 1.08125
To get from a percent to a number, you simply move the decimal point two places to the left. (math is my strong point)
Therefore, 108.125 (move decimal two places left) is equal to 1.08125. So then, 2829.00/1.08125 = 2616.416
Kevin
-
06-13-2006, 12:06 PM #5Web Hosting Master
- Join Date
- Dec 2003
- Location
- Fairfax, Virginia
- Posts
- 6,834
Originally Posted by kvnband
-
06-13-2006, 11:16 AM #6Web Hosting Master
- Join Date
- Nov 2002
- Posts
- 4,667
How to use the % sign on a calculator:
http://www.staff.vu.edu.au/mcaonline...lculators.html
-
06-13-2006, 11:28 AM #7
Ah...coming back to me now, thanks kvnband.
Wonder why calc was choking on it being expressed the other way?Your one stop shop for decentralization
-
06-13-2006, 12:11 PM #8Web Hosting Master
- Join Date
- Feb 2003
- Location
- AR
- Posts
- 2,382
I was just throwing it out there for anyone who wishes to use that ever so helpful information. I'm a math major, so I do believe I could be of some assistance when someone is needing math help
-
06-13-2006, 01:02 PM #9Web Hosting Master
- Join Date
- Oct 2001
- Location
- South England
- Posts
- 1,121
You can't beat an electronic calculator, for those important sums
-
06-13-2006, 03:29 PM #10Originally Posted by Koopa
It's the operator that lacks certain abilities...Your one stop shop for decentralization
-
06-13-2006, 04:01 PM #11Web Hosting Master
- Join Date
- Aug 2000
- Location
- NYC
- Posts
- 6,623
It's just the algebraic logic that calc uses -- as do a lot of other simple calculators.
When you enter 2829.00 / 108.125 % you are asking for 108.125% of 2829. That division sign hasn't done anything yet, because the calculator is still awaiting the end of the equation. If you press equal after that, you'll get to the end of what's anticipated by that approach: 2829.00 divided by 108.125% of 2829.00.
That might not seem entirely useful, but the approach is aimed at a kind of calculation that is often done on simple calculators: adding percentages.
For example by entering 2829 + 8 % = you'll get 8% of 2829 added to that original 2829. That's a common type of calculation (adding a tip, or tax) for which a simple calculator might be used.
So it's not an error at all, it's just one of several approaches to data entry logic that might be used by a calculator.
-
06-13-2006, 04:14 PM #12
So, even though I entered it as divide by nnn%, it determines that what I really wanted was to multiply by that amount based on the % at the end? Kind if flawed logic, I feel, since if I wanted to multiply, I'd have used *. No idea that calc would "help" me in this way.
Defeated by a simple calc program....a misspent youth is finally haunting me...Your one stop shop for decentralization
-
06-13-2006, 04:31 PM #13Web Hosting Master
- Join Date
- Aug 2000
- Location
- NYC
- Posts
- 6,623
Originally Posted by bear
Maybe it is flawed logic, unless it's what you want to do.