Trunc Function in Excel
TRUNC removes the fractional part of the number based on an (optional) number of digits. For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3. The TRUNC function does no rounding, it simply truncates as specified.
The TRUNC function takes two arguments: number and num_digits. Number is the numeric value to truncate. The num_digits argument is optional and specifies the place at which number should be truncated. Num_digits defaults to zero (0).
Syntax
=TRUNC (number, [num_digits])
Arguments
number - The number to truncate.
num_digits - [optional] The precision of the truncation (default is 0).
Note that:
A positive [num_digits] value specifies the number of digits to the right of the decimal point;
If [num_digits] is 0 (or is omitted), the supplied number is truncated to the nearest integer;
A negative [num_digits] value specifies the number of digits to the left of the decimal point.
#shorts #short #shortvideo #shortsfeed #shortsvideo #shortsyoutube #shortfeed #shortvideos #zillion #zilliontrainings #trainingshorts #excel #exceltutorial #sabur #saburudeen #saboor #exceltips #exceltricks #excelformula #excelformulas