Office tutorials

Excel VBA Functions

Numeric functions:

ABS – Returns absolute value of a number.
EXP – Returns exponential value of a number.
FIX – Returns integer value of a number. Rounds negative numbers up.
INT – Returns integer value of a number. Rounds negative numbers down.
LOG – Returns the value of the natural logarithm of the argument.
RND – Generates a random number in the 0-1 range.
ROUND – Rounds the number indicated in the argument to the specified number of decimal places.
SQR – Oblicza pierwiastek drugiego stopnia ze wskazanej liczby.
SGN – Zwraca znak liczby. Dla dodatnich 1, dla ujemnych -1.
SIN – Returns sinus of a value.
COS – Returns cosinus of a value.
TAN – Returns tangens of a value.
ATN – Returns arcustangens of a value.