
#1
Oct2213, 12:45 PM

PF Gold
P: 776

Hi there,
If I perform the following calculation in Excel: =100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,00 0,000,000,000,000,000,000,000,000+50 I get: 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000 ,000,000,000,000,000,000,000,000 Shouldn't the answer be: 100,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000 ,000,000,000,000,000,000,000,050? 



#2
Oct2213, 02:41 PM

PF Gold
P: 5,682

No, the answer will be constrained by the number of bits used by the computer to represent the numbers, and you've got WAY more than it can handle, so the 50 gets dropped as a rounding error.




#3
Oct2213, 02:59 PM

Mentor
P: 11,231

According to
http://en.wikipedia.org/wiki/Numeric...icrosoft_Excel numbers in Excel are limited to 15 significant figures. So 100,000,000,000,000+50 works, but 100,000,000,000,000,000+50 doesn't. 



#4
Oct2213, 03:55 PM

PF Gold
P: 776

Excel + Calculations
Is there any other program out there that will present the result given in my original post?




#5
Oct2413, 03:57 PM

P: 972

Lots of other programs can do that.
Computer Algebra Systems, like Mathematica, Sage, Maxima, Reduce, Maple... all do that. http://en.wikipedia.org/wiki/Computer_algebra_system Some calculator programs, like bc and many others do that. https://www.google.com/search?q=big+...ger+calculator Many programming languages, like Icon, Java... do that, don't be fooled by those who think 64 bits is big. https://www.google.com/search?q=prog...ge+big+integer 



#6
Oct3013, 02:11 AM

Sci Advisor
PF Gold
P: 9,182

64 bits is chump change for deep calculations. You need a monster computer to process calculations beyond a few hundred decimal points. That is why numerical analysis takes so long and is so incredibly expensive.




#8
Oct3013, 03:00 PM

PF Gold
P: 5,682





#9
Oct3113, 01:05 AM

P: 322




Register to reply 
Related Discussions  
Calculating a and b in excel (any excel masters)?  Introductory Physics Homework  4  
Excel Bug?  Math & Science Software  2  
Need Testing and Feedback on Excel Coil Calculations Sheet (Part 2)  Electrical Engineering  0  
Need Testing and Feedback on Excel Coil Calculations Sheet  Electrical Engineering  0  
generate a function on excel  Computing & Technology  3 