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

Windows calculator vs Excel

 Send news tip View All Posts Thread Tools Search this Thread Display Modes
#1
06-13-2006, 08:59 AM
 bear Community Leader Join Date: Oct 2002 Location: cognito Posts: 17,435

# 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
If at first you don't succeed, that's one data point.

#2
06-13-2006, 10:28 AM
 ThatScriptGuy Web Hosting Master Join Date: Feb 2003 Location: AR Posts: 2,370
Calc gave me 2616.416
Kevin

(2829.00/1.08125)

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

#3
06-13-2006, 11:14 AM
 bear Community Leader Join Date: Oct 2002 Location: cognito Posts: 17,435
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
If at first you don't succeed, that's one data point.

#4
06-13-2006, 11:16 AM
 ThatScriptGuy Web Hosting Master Join Date: Feb 2003 Location: AR Posts: 2,370
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 Conway, Arkansas based development company.
501-205-1512

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

#6
06-13-2006, 11:28 AM
 bear Community Leader Join Date: Oct 2002 Location: cognito Posts: 17,435
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
If at first you don't succeed, that's one data point.

#7
06-13-2006, 12:06 PM
 SniperDevil 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
06-13-2006, 12:11 PM
 ThatScriptGuy Web Hosting Master Join Date: Feb 2003 Location: AR Posts: 2,370
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 Conway, Arkansas based development company.
501-205-1512

#9
06-13-2006, 01:02 PM
 Koopa 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
06-13-2006, 03:29 PM
 bear Community Leader Join Date: Oct 2002 Location: cognito Posts: 17,435
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
If at first you don't succeed, that's one data point.

#11
06-13-2006, 04:01 PM
 JayC 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
06-13-2006, 04:14 PM
 bear Community Leader Join Date: Oct 2002 Location: cognito Posts: 17,435
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
If at first you don't succeed, that's one data point.

#13
06-13-2006, 04:31 PM
 JayC 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.

 Related posts from TheWhir.com Title Type Date Posted Expired SSL Certificate Brings Down Windows Azure Cloud Web Hosting News 2013-02-25 10:38:00 Windows Azure Processes 4.7 Billion Authentication Requests Weekly Web Hosting News 2012-11-27 17:21:03 Web Host OrcsWeb Offers Support for Windows Server 2012 Web Hosting News 2012-08-24 11:08:35 Netwise Hosting Launches Real-time Colocation Cost Calculator Web Hosting News 2012-06-22 15:00:14 Security Firm StillSecure Launches Free PCI Calculator for Retailers Web Hosting News 2011-07-06 16:56:39

 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 Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Premium & Corporate Member Forums     Premium & Corporate Members         Marketing, Promotion, and Customer Service         Infrastructure & Hosting Company Discussions         Fraud and Abuse         WebHostingTalk Subscribers Club Web Hosting Main Forums     Industry Announcements         Web Hosting Industry Announcements         Providers and Network Outages and Updates     Web Hosting         i2C - Internet Infrastructure Coalition         Windows Hosting         Web Hosting Tutorials     Dedicated Server     Colocation and Data Centers         Colocation Hosting Tutorials     Cloud Hosting         Cloud Hosting Tutorials     Specialty Hosting and Markets         Green Hosting         VOIP etc         Game Servers     VPS Hosting         VPS Tutorials     Reseller Hosting     Managed Hosting and Services     Hosting Security and Technology         Hosting Security and Technology Tutorials     Programming Discussion         Programming Tutorials     Hosting Software and Control Panels         Hosting Software and Control Panels Tutorials     Running a Web Hosting Business         Running a Web Hosting Business Tutorials     Ecommerce Hosting & Discussion     Domain Names         Domain Name Tutorials     Web Design and Content         Web Design and Content Tutorials     SEO / SEM Discussions Other Forums     Web Hosting Lounge         New Members         Web Hosting Chat Club     Web Hosting Meetups and Networking     WHT Announcements, Feedback and Questions     Computers and Peripherals         Mobile and Handheld Devices         Computers and Peripherals Tutorials     HostingCon         From the HostingCon Blog     WHT Community Groups Advertising Forums     Web Hosting Offers         Shared Hosting Offers         Reseller Hosting Offers         Dedicated Hosting Offers         Colo Hosting Offers         VPS Hosting Offers         Cloud Hosting Offers         Hosted Email Offers         Managed Service Provider Offers         Other Hosting Offers     Domain Names Advertising         Domain Name Offers         Domain Name Requests         Domain Name with Web Site Offers         Domain Name with Web Site Requests         Domain Name Appraisals     Employment Offers & Requests         Employment / Job Offers         Employment / Job Requests         Systems Management Offers         Systems Management Requests     Design Job Offers & Requests         Design Offers         Design Requests     Software & Scripts Offers & Requests         Software & Scripts Offers         Software & Scripts Requests         SaaS Offers         SaaS Requests     Marketing & SEO Services         Advertising Offers         Advertising Requests         Marketing Services Offers         Marketing Services Requests         SEO Job Offers         SEO Job Requests     Web Hosting Related Offers & Requests         Web Hosting Companies And Clients For Sale or Purchase         Gaming Servers Hosting Offers         Web Hosting Hardware         Broadband Providers         Card & Payment Services         Hosting & Network Security         Content Delivery & Streaming Media Hosting Offers         Backup Services         Other Web Hosting Related Offers         Other Web Hosting Related Requests         Other Offers & Requests     Free Hosting Offers & Requests     Paid Hosting Requests     Community Reviews         Web Site Reviews         Other Reviews