Numbers



VBA.Abs

ABS - Returns the absolute value of a number.



VBA.Fix

FIX - Returns the integer portion of a number.



VBA.Int

INT - Returns the number rounded down to the nearest integer.



VBA.Round

ROUND - Returns a number rounded to a given number of decimal places.

Dim dbValue As Double 
dbValue = 0.9
Round(dbValue) = 1


dbValue = 0.9
Round(dbValue,1) = 0.9

VBA.Sgn

SGN - Returns the sign of a number.





© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext