Rounding in a function (A2000)

Topic

New Reply

How would I round this expression to 2 decimal places? fMatch = ((curYTDE + curCE) * 0.03) – curYTDM

Reply | Quote

Replies

Thanks Chris, that works for me, too.

Reply | Quote

I don’t think using CLng will work. I would use the function below as follows:

fMatch = gfRound2( ((curYTDE + curCE) * 0.03) – curYTDM)

However, you might want to round prior to the subtraction, depending on your situation.

Public Function gfRound2(ByRef RawData) As Currency
  ' This function rounds the "RawData" input to 2 decimal places.
  gfRound2 = CCur(CCur(RawData) / 100) * 100
End Function

Reply | Quote

Try this:

fMatch = Round(((curYTDE + curCE) * 0.03) – curYTDM,2)

There wasn’t a built-in round function in earlier versions, but there is in 2000. Just be aware that it doesn’t work like the Excel rounding functions. This one only rounds up if the determinant is greater than 5.

Reply | Quote

Thanks, Charlotte, that was what I was looking for!

Reply | Quote