My Digital Quill | Excel Formulas and Functions #23 | TRUNC Function in Excel | Excel tips and tricks | Excel #shorts
This example explains on how to use TRUNC function in Excel. The syntax of the function contains two arguments, where first argument requires the location of the cell containing the number to be truncated or number itself. The second argument requires the number after the decimal points to be defined.
The TRUNC is a math function in Excel used in cases where you have to highlight the residual number or have this referenced somewhere else. This function can work wonders in applying precision with smartness to your worksheet!
Credits:
Thumbnail Photo by Justin Morgan on Unsplash
Ajay Anand
• Excel formula to remove digits after ...
Please check out more Excel tips and tricks from the playlist link down below:
• Excel Tips and Tricks
Check this playlist for Excel formulas and functions:
• Excel Formulas and Functions Series
Free Excel Course available on formatting techniques in here:
• Excel Formatting Techniques
🔔 Subscribe for free Office Tutorials at My Digital Quill:
/ @mydigitalquill8945
#truncfunction #truncfunctioninexcel #exceltruncfunction #excelmathfunctions #Excelformulasandfunctions #Exceltipsand tricks #Excelshorts
#MyDigitalQuill
Смотрите видео #shorts онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал My Digital Quill 01 Январь 2022. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 164 раз и оно понравилось 10 посетителям.