Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |