Round down .5 in VBA Math.Round function

[Ace71425]

This code below looks at field c2 in hours worksheet and writes the text "hours" x amount of times based on the value in that field to the work worksheet. It works great BUT I need it to round DOWN any .5 value instead of rounding up. Is that possible? Can I put like an IF statement that specifies what to do if the value is x.5?

Sub Test()
    Application.ScreenUpdating = False
    Dim bottomD As Long
    bottomD = Sheets("Work").Range("D" & Rows.Count).End(xlUp).Row
    Sheets("Work").Range("D" & bottomD + 1 & ":D" & bottomD + Math.Round(Sheets("Hours").Range("C2"), 0)) = "HOURS"
    Application.ScreenUpdating = True
End Sub

 

[mikerickson]

Have you tried using WorksheetFunction.RoundDown?

 

[Ace71425]

No where would I insert that? and that wouldnt round down .75 value also would it?