Rounding Numbers

Hello VBA Forum,

Does anyone know how to display this number rounded to 1 decimal place?

Please Login or Register  to view this content.

I know how to display a "rounded" single variable, but not the above where there are 2 variables added then divided by 2.

Thanks for any help that can be given.

Please try

MsgBox "The Total For This Game Should Be " & round((TopPitcherAveTotalNum + BottomPitcherAveTotalNum) / 2, 1)

Thank You, Bo_Ry. That was it.

You should be very careful about vba Round function, so better use WorkSheetFunction.Round.

VBA Round is a Banking round and you see the difference.

Please Login or Register  to view this content.