Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X
I have copied values from Excel into Mathcad 15 and see one error:
The Mathcad 15 sheet in attach
Same in Prime
Valery Ochkov wrote:
I have copied values from Excel into Mathcad 15 and see one error:
Thats not an error but just a side effect where you can see that under the hood Mathcad is not dealing with integers (like Derive and other exact math progs) but is using IEEE floats with all their drawbacks. Whenever you perform calculations or conversions with that kind of numbers (and you obviously do when you copy from Excel and excpect Mathcad to convert the 1E-28 notation) you can see those effects. At the level of precision provided by the program 10^-44 IS zero.
Werner Exinger wrote:
Valery Ochkov wrote:
I have copied values from Excel into Mathcad 15 and see one error:
Thats not an error
but I have created one Mathcad sheet with copy coeffs from Excel I have this error
Valery Ochkov wrote:
Werner Exinger wrote:
Valery Ochkov wrote:
I have copied values from Excel into Mathcad 15 and see one error:
Thats not an error
but I have created one Mathcad sheet with copy coeffs from Excel I have this error
OK, to be more precise - it is indeed an error. What I meant is that its not a bug but just some kind of roundoff/convesion error. Dealing with float numbers you never should ask if two numbers are (exactly) equal but always if those two numbers are sufficently close by looking if the absolute value of their difference is smaller than a small threshold epsilon. And I guess that 10^-44 qualifies.