Explanation
The Excel TRUNC function does no rounding, it just returns a truncated number.
It has an optional second argument (num_digits) to specify precision.
Whennum_digitsis not provided, it defaults to zero.
Additional conditions can be added with the AND function.
Notes: Data validation rules are triggered when a user adds or changes a cell value.
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.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
The AND function is commonly used with other…
