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 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 […]
Excel’s Golden Rule Full Rule: If a formula input can change, put it into a cell and refer to it in the formula with a cell reference. If a formula input will not change, you […]
Determine Quarter For column of Dates: CHOOSE or CEILING function? DESCRIPTION See Mr Excel and excelisfun use two methods to create a formula that can take any date and determine what quarter it is. See […]
Master Excel
Leave a Reply
You must be logged in to post a comment.