Rounding Down

  • Thread starter Thread starter J
  • Start date Start date
J

J

I have a form where I need to have any number from 99.01 up to 99.99
rounded down to 99. This is done through a click event. It doesn't
matter about any number from 0-99 because this number represents a
completion status percentage and I just don't want a 99.6 appearing as
100% because the project would appear to be completed but would still
have work left to do. I was thinking about something like a nested IF
statement something like:

If FinalTotal > 99 Then
If FinalTotal < 100 Then
FinalTotal = 99
Forms![Status wk 01]![Completion Status] = Round(FinalTotal * 100,
" ")
Else
Forms![Status wk 01]![Completion Status] = 100
End If
End If

But apparently it doesn't seem to work correctly. I could use some
insight on other methods that could help solve my problem.
 
Use Int instead of Round. Int returns the Integer portion of the number, so
it has the same effect as forcing a round down.

Int(99.01) returns 99, and Int(99.999) also returns 99. Int(100) returns 100.

Try this: If FinalTotal > 99 Then FinalTotal = Int(FinalTotal)
 
Back
Top