Kann mir jemand meinen Makroschnipsel ergänzen - siehe Anhang
https://www.herber.de/bbs/user/100775.xlsm
vielen Dank
Pepi
Cells(4, 2) = Round(iDou, 2)
Sub VerruecktesRunden() 'Su151015
Dim sTmp$
sTmp = "0.5 = " & Round(0.5, 0) & vbTab & Application.Round(0.5, 0) & vbLf & "1.5 = " & Round(1. _
5, 0) & vbTab & Application.Round(1.5, 0) & vbLf & "2.5 = " & Round(2.5, 0) & vbTab & Application.Round(2.5, 0) & vbLf & "3.5 = " & Round(3.5, 0) & vbTab & Application.Round(3.5, 0) & vbLf & "4.5 = " & Round(4.5, 0) & vbTab & Application.Round(4.5, 0) & vbLf & "5.5 = " & Round(5.5, 0) & vbTab & Application.Round(5.5, 0) & vbLf & vbLf
sTmp = sTmp & "0.49 = " & Round(0.49, 0) & vbTab & Application.Round(0.49, 0) & vbLf & "1.49 = " _
& Round(1.49, 0) & vbTab & Application.Round(1.49, 0) & vbLf & "2.49 = " & Round(2.49, 0) & vbTab & Application.Round(2.49, 0) & vbLf & "3.49 = " & Round(3.49, 0) & vbTab & Application.Round(3.49, 0) & vbLf & "4.49 = " & Round(4.49, 0) & vbTab & Application.Round(4.49, 0) & vbLf & "5.49 = " & Round(5.49, 0) & vbTab & Application.Round(5.49, 0) & vbLf & vbLf
sTmp = sTmp & "0.22 = " & Round(0.22, 0) & vbTab & Application.RoundUp(0.22, 0) & vbLf & "1.22 = _
" & Round(1.22, 0) & vbTab & Application.RoundUp(1.22, 0) & vbLf & "2.22 = " & Round(2.22, 0) & vbTab & Application.RoundUp(2.22, 0) & vbLf & "3.22 = " & Round(3.22, 0) & vbTab & Application.RoundUp(3.22, 0) & vbLf & "4.22 = " & Round(4.22, 0) & vbTab & Application.RoundUp(4.22, 0) & vbLf & "5.22 = " & Round(5.22, 0) & vbTab & Application.RoundUp(5.22, 0) & vbLf & vbLf
sTmp = sTmp & "0.88 = " & Round(0.88, 0) & vbTab & Application.RoundDown(0.88, 0) & vbLf & "1. _
88 = " & Round(1.88, 0) & vbTab & Application.RoundDown(1.88, 0) & vbLf & "2.88 = " & Round(2.88, 0) & vbTab & Application.RoundDown(2.88, 0) & vbLf & "3.88 = " & Round(3.88, 0) & vbTab & Application.RoundDown(3.88, 0) & vbLf & "4.88 = " & Round(4.88, 0) & vbTab & Application.RoundDown(4.88, 0) & vbLf & "5.88 = " & Round(5.88, 0) & vbTab & Application.RoundDown(5.88, 0)
MsgBox sTmp '0-2-2-4-4-6
'round() scheint nicht immer richtig zu funktionieren, Application.round() hingegen schon
End Sub