Geek Answers Handbook

Get epsilon machine in Microsoft Excel

This seems like a question that is better targeted at those who have programming experience, and not just ordinary Excel users, so I ask here, not Superuser.

Is there any way, preferably through a function, to return epsilon (i.e. the smallest nonzero number represented in Excel calculations)? If it cannot be restored via a function, is there a quick way to calculate it through a compact function?

To be clear, I am not looking for a solution based on VBA, I would like to get a solution based on a formula / table in Excel that does not require running macros.

My searches on the web basically included discussions on how to display the Epsilon symbol.

Thank.

+5
source share
3

Excel IEEE.

-VBA-, - 0,

=2^-1022

epsilon, , , 1 , 1.

=2^-52
+7

Microsoft XL. 2.2250738585072E-308 Microsoft: 78113. , 0, 2.2250738585073E-308, ( 1 ), . , epsilon, XL, , , epsilon C/++. . xlfRegister ( 1) Microsoft Developer Network.

+4

VBA, :

 Public Sub ComputeMachineEpsilon()
     Dim g, ex, eps As Double
     Dim i As Long
     g = 1
     i = 0
     Do
        i = i + 1
        g = g / 2
        ex = g * 0.98 + 1
        ex = ex - 1
        If ex > 0 Then eps = ex
     Loop While ex > 0

     MsgBox ("No. of Iterations " & i)
     MsgBox ("Machine Epsilon is " & eps)

    End Sub

2,22E-16, , =2^-113 9,62965E-35.

=1*(0,5-0,4-0,1)

: -2,78E-17

+2

More articles:


All Articles