Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Rounding to nearest 0.05 1
- Thread starter TLOTRfan
- Start date
-
1
- #2
JoeCrystal
Programmer
You could use a formula something like:
Dim x as Number
x = 1.56
If Remainder (x, 0.05) < 0.025 Then
Formula = x - Remainder (x, 0.05)
Else
Formula = x + (0.05 - Remainder (x, 0.05))
End If
If you can have negative number than you will have to modify this slightly to work.
Dim x as Number
x = 1.56
If Remainder (x, 0.05) < 0.025 Then
Formula = x - Remainder (x, 0.05)
Else
Formula = x + (0.05 - Remainder (x, 0.05))
End If
If you can have negative number than you will have to modify this slightly to work.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question