TRUNC

Definition: The TRUNC function in Excel is used to truncate a number to an integer by removing the decimal portion of the number.

Syntax: ==TRUNC(number, [num_digits]).

Situation: This formula is appropriate in situations where you need to truncate a number to an integer.

Example: If you have a number 3.14159 and you want to truncate it to an integer, you would use the formula =TRUNC(3.14159). This would return a value of 3.