The Excel function to remove decimal or fractional part of the number is:

Question

Question

This question was previously asked in

OSSC TGT Official Paper (Held On: 10 Mar, 2023 Shift 3)

Answer 1

The correct answer is TRUNC.

Key Points

TRUNC function is used to remove the fractional part of a number, effectively truncating it to an integer.
It does not perform any rounding, it simply cuts off the decimal part.
The syntax for the TRUNC function is TRUNC(number, [num_digits]).
It can also truncate the number to a specified number of decimal places if the num_digits argument is provided.

Important Points

The TRUNC function is different from the ROUND function, as ROUND performs rounding based on the decimal part, while TRUNC simply cuts it off.
Using TRUNC can be useful in scenarios where only the integer part of a number is needed without any rounding.
It is a useful function in data analysis, financial calculations, and other areas where precision control is required.
TRUNC can be combined with other functions to achieve more complex calculations.

Additional Information

AVG: The AVG function calculates the average (mean) of a group of numbers. It is commonly used in data analysis to determine the central tendency of a data set.
REPLACE: The REPLACE function is used to replace part of a text string with a different text string. It is useful for text manipulation and formatting.
ABS: The ABS function returns the absolute value of a number, which is the number without its sign. It is useful in mathematical calculations where negative values are not desired.