roundup function conflict with null values
I have this function:
Public Function RoundUp(number As Double, significant As Integer) As Double
RoundUp = Round(number, significant)
If RoundUp < number Then
RoundUp = RoundUp + (1 / (10 * significant))
End If
End Function
The problem is that when a txtA has a Null value then txtB = RoundUp([txtA],2) = #ERROR, instead of #ERROR I will like it to be Null too. I have tried the NZ function but it doesn't converts #ERROR to Null.
Please help.
Thanks
|