Scribd
Upload
7 views1 page

4.math Functions

The document outlines various mathematical functions used for data manipulation, including INT(), CURRENCY(), ROUND(), ROUNDUP(), and ROUNDDOWN(). It explains how to convert values, round numbers, and perform calculations like division and factorials. Additionally, it describes functions for determining the sign of a number and rounding to even or odd integers.

Uploaded by

nandinimugadur
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views1 page

4.math Functions

The document outlines various mathematical functions used for data manipulation, including INT(), CURRENCY(), ROUND(), ROUNDUP(), and ROUNDDOWN(). It explains how to convert values, round numbers, and perform calculations like division and factorials. Additionally, it describes functions for determining the sign of a number and rounding to even or odd integers.

Uploaded by

nandinimugadur
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

MATH FUNCTIONS

MATH FUNCTIONS:-
INT() - Converts to int, Removes Decimals ,
SalaryInt = INT(Emp[Salary])
CURRENCY():- CONVERTS INTO MONEY ,
SalesAmount = CURRENCY(sales[SalesAmount])
ROUND() - It rounds the number to the given number of digits.
If the decimal point is >=5 it will round to next value or else previous value.
RoundSalary = ROUND(Emp[Salary],0) ---> 0 - Number of decimals.
ROUNDUP() - It will always round to the next value.
ROUNDDOWN()- It will always round to the Previous value.
DIVIDE():-DIVIDE(Numerator/Denominator,[AlternateResult]) AnyValue/0 =Infinity - Intead I
want to use 0 /AlternateValue
If you do not give zero then shows null.
EVEN()-Round up the number to next even nearest integer.
ODD()-Round up the number to next odd nearest integer.

POWER() - POWER(2,2)-4 ,POWER(3,2)-9


SQRT() - Square root of a number.
FACTORIAL()- FACTORIAL(5) - 5*4*3*2*1
SIGN()- Returns 1 if number is positive.
Returns 0 if number is o.
Returns -1 if number is negative.
Used to show the number of profit,loss and 0 orders.
1
Page

THARUN CHALLA 1

You might also like