Basic math functions: round, rounddown, roundup, sign

Excel Function ROUND

The ROUND() function is used to round a given number to the specified number of decimal places.

The ROUND() function takes two parameters; number and num_digits.

A positive value in the number of digits specifies the number of digits to the right of decimal point.

A negative value in the number of digits specifies the number of digits to the left of decimal point.

A value of 0 rounds the number to its nearest integer.

 Number No. of digits Formula ROUND() 23.466 2 =ROUND(L4,M4) 23.47 4 1 =ROUND(L5,M5) 4 23.098981 -1 =ROUND(L6,M6) 20 -887 -1 =ROUND(L7,M7) -890 0.2344 2 =ROUND(L8,M8) 0.23

Excel Function ROUNDDOWN

The ROUNDDOWN() function is used to round a number downwards.

This function always rounds the number downwards and takes two parameters; number and digits.

If the digits is 0, then the number is rounded down to the nearest integer.

If the digits is greater than 0, then the number is rounded to the specified decimal places.

If the digits is less than 0, then the number is rounded to the left of the decimal places.

 Number No. of digits Formula ROUNDDOWN() 23.466 2 =ROUNDDOWN(L18,M18) 23.46 4 1 =ROUNDDOWN(L19,M19) 4 23.098981 -1 =ROUNDDOWN(L20,M20) 20 -887 -1 =ROUNDDOWN(L21,M21) -880 0.2344 2 =ROUNDDOWN(L22,M22) 0.23

Excel Function ROUNDUP

The ROUNDUP() function is used to round a number upwards.

This function always rounds the number upwards and takes two parameters; number and digits.

If the digits is 0, then the number is rounded down to the nearest integer.

If the digits is greater than 0, then the number is rounded to the specified decimal places.

If the digits is less than 0, then the number is rounded to the left of the decimal places.

 Number No. of digits Formula ROUNDUP() 23.466 2 =ROUNDUP(L32,M32) 23.47 4 1 =ROUNDUP(L33,M33) 4 23.098981 -1 =ROUNDUP(L34,M34) 30 -887 -1 =ROUNDUP(L35,M35) -890 0.2344 2 =ROUNDUP(L36,M36) 0.24

Excel Function SIGN

The SIGN() function is used to determine the arithmetic sign of the given number.

This function takes a single parameter; number.

If the number is positive, then arithmetic sign 1 is returned.

If the number is negative, then arithmetic sign -1 is returned.

If the number is 0, then 0 is returned.

 Number Formula SIGN() 23 SIGN(L46) 1 -22 SIGN(L47) -1 2 SIGN(L48) 1 3000 SIGN(L49) 1 0 SIGN(L50) 0