#shorts

Published: 01 January 2022
on channel: My Digital Quill

164

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, duration hours minute second in high quality that is uploaded to the channel My Digital Quill 01 January 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 164 times and liked it 10 visitors.