#shorts
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
Watch video #shorts online without registration, duration hours minute second in high quality. This video was added by user My Digital Quill 01 January 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 164 once and liked it 10 people.