Topics in this video:
(00:09) ROUND function so Invoices and Payroll spreadsheets are accurate.
(03:49) ROUND to the penny, dollar or thousands position.
(04:28) ROUND, ROUNDUP, ROUNDDOWN functions round to a digit or position.
(05:48) MROUND, CEILING and FLOOR round to an amount or multiple.
DESCRIPTION Formulas for Quarters, Fiscal Quarters & Fiscal Years: (00:07) Quarters using CEILING and MONTH function (02:48) Fiscal Quarter using LOOKUP and MONTH (05:24) Fiscal Quarter using IF, MONTH and CEILING (06:40) Fiscal Year using […]
DESCRIPTION See how to: (00:17) Calendar Table in Diagram View with no Calculated Fields (00:58) Format Date Column (01:08) Create Calculated Column #01: Month Number using MONTH function. (01:53) Create Calculated Column #02: Month Name […]
Round Invoice: ROUND or SUMPRODUCT – ROUND DESCRIPTION See Mr Excel and excelisfun use two methods to round the amounts on an Invoice so the SUM total is correct. WORKBOOKS
Master Excel
Leave a Reply
You must be logged in to post a comment.