hosted by liquidweb


Go Back   Web Hosting Talk : Other Forums : Computers and Peripherals : Windows calculator vs Excel
Reply

Forum Jump

Windows calculator vs Excel

Reply Post New Thread In Computers and Peripherals Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 06-13-2006, 08:59 AM
bear bear is offline
Community Leader
 
Join Date: Oct 2002
Location: Mayberry
Posts: 19,059

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?

__________________
Have problems (don't we all)? Head over to the help desk





Sponsored Links
  #2  
Old 06-13-2006, 10:28 AM
ThatScriptGuy ThatScriptGuy is offline
Web Hosting Master
 
Join Date: Feb 2003
Location: AR
Posts: 2,377
Calc gave me 2616.416
Kevin

(2829.00/1.08125)

__________________
Kevin Cackler
Tech Daddies - A Russellville, Arkansas based development company.
501-205-1512

  #3  
Old 06-13-2006, 11:14 AM
bear bear is offline
Community Leader
 
Join Date: Oct 2002
Location: Mayberry
Posts: 19,059
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.

__________________
Have problems (don't we all)? Head over to the help desk



Sponsored Links
  #4  
Old 06-13-2006, 11:16 AM
ThatScriptGuy ThatScriptGuy is offline
Web Hosting Master
 
Join Date: Feb 2003
Location: AR
Posts: 2,377
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

__________________
Kevin Cackler
Tech Daddies - A Russellville, Arkansas based development company.
501-205-1512

  #5  
Old 06-13-2006, 11:16 AM
Techno Techno is offline
Web Hosting Master
 
Join Date: Nov 2002
Posts: 3,907
How to use the % sign on a calculator:
http://www.staff.vu.edu.au/mcaonline...lculators.html

  #6  
Old 06-13-2006, 11:28 AM
bear bear is offline
Community Leader
 
Join Date: Oct 2002
Location: Mayberry
Posts: 19,059
Ah...coming back to me now, thanks kvnband.
Wonder why calc was choking on it being expressed the other way?

__________________
Have problems (don't we all)? Head over to the help desk



  #7  
Old 06-13-2006, 12:06 PM
SniperDevil SniperDevil is offline
Web Hosting Master
 
Join Date: Dec 2003
Location: Fairfax, Virginia
Posts: 6,835
Quote:
Originally Posted by kvnband
(math is my strong point)
Not to detract from your innate abilities, but it doesn't exactly take a math genius to understand what a percentage means and, therefore, to be able to convert it to a decimal.

  #8  
Old 06-13-2006, 12:11 PM
ThatScriptGuy ThatScriptGuy is offline
Web Hosting Master
 
Join Date: Feb 2003
Location: AR
Posts: 2,377
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

__________________
Kevin Cackler
Tech Daddies - A Russellville, Arkansas based development company.
501-205-1512

  #9  
Old 06-13-2006, 01:02 PM
Koopa Koopa is offline
Web Hosting Master
 
Join Date: Oct 2001
Location: South England
Posts: 1,121
You can't beat an electronic calculator, for those important sums

  #10  
Old 06-13-2006, 03:29 PM
bear bear is offline
Community Leader
 
Join Date: Oct 2002
Location: Mayberry
Posts: 19,059
Quote:
Originally Posted by Koopa
You can't beat an electronic calculator, for those important sums
My computer uses electricity....
It's the operator that lacks certain abilities...

__________________
Have problems (don't we all)? Head over to the help desk



  #11  
Old 06-13-2006, 04:01 PM
JayC JayC is offline
Web Hosting Master
 
Join Date: Aug 2000
Location: NYC
Posts: 6,627
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.

  #12  
Old 06-13-2006, 04:14 PM
bear bear is offline
Community Leader
 
Join Date: Oct 2002
Location: Mayberry
Posts: 19,059
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...

__________________
Have problems (don't we all)? Head over to the help desk



  #13  
Old 06-13-2006, 04:31 PM
JayC JayC is offline
Web Hosting Master
 
Join Date: Aug 2000
Location: NYC
Posts: 6,627
Quote:
Originally Posted by bear
So, even though I entered it as divide by nnn%,
It would have divided, but it would have divided the first number by nnn% [i]of the first number[/], not just by nnn%.

Maybe it is flawed logic, unless it's what you want to do.

Reply

Related posts from TheWhir.com
Title Type Date Posted
Open Source Collaboration Provider Open-Xchange Launches OX Spreadsheet Tool: WHD.global 2014 Web Hosting News 2014-04-01 11:18:13
Microsoft Surpasses Amazon as Largest Windows Hosting Company: Netcraft Web Hosting News 2014-02-27 17:05:44
Web hosting provider Infinitely Virtual Offers Unbundled Microsoft Office Suite Products Web Hosting News 2012-08-14 18:22:53
Desktop Hosting: High-Margin Opportunity for a New Cloud Service – WPC 2012 Web Hosting News 2012-07-11 14:57:43
Netwise Hosting Launches Real-time Colocation Cost Calculator Web Hosting News 2012-06-22 15:00:14


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?