Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing double values
What is the best method for comparing double values. The following loop
produces one too many values. Dim dblStep As Double Dim dblT As Double Dim dlbTMax As Double dblStep = 0.005 dblTMax = 0.060 dblT = 0.0 While dblT < dblTMax MsgBox Str(dblT) dblT = dblT + dblStep Wend Produces: 0.000 0.005 0.010 0.015 0.020 0.025 0.030 0.035 0.040 0.045 0.050 0.055 0.060 <- This one should not have been produced. *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to double values in a cell | Excel Worksheet Functions | |||
Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
Comparing values between columns only when there are values in bot | Excel Worksheet Functions | |||
Comparing values in two columns and displaying missing values in n | Excel Programming | |||
Comparing Values | Excel Programming |