Code:
Function f(billAmount)
If mid(billAmount,2,1)<5 Then
f=mid(billAmount,1,1)*100
else
f=(mid(billAmount,1,1)+1)*100
End If
End Function
NetAmount=f(140)
Help on Round Off value
|
« Next Oldest | Next Newest »
|
Messages In This Thread |
Help on Round Off value - by AutomationTester2011 - 07-19-2011, 05:11 PM
RE: Help on Round Off value - by rajpes - 07-19-2011, 05:37 PM
RE: Help on Round Off value - by tdevick - 07-19-2011, 10:10 PM
RE: Help on Round Off value - by rajpes - 07-19-2011, 10:41 PM
|