Excel Is Fun

Excel Magic Trick 1333

October 11, 2017 0

DESCRIPTION Learn about Banker’s Rounding or Gaussian Rounding: (00:15) What is Banker’s Rounding? (02:30) Normal Excel ROUND Function (Arithmetic Rounding, NOT Banker’s Rounding) (03:18) Excel formula to do Banker’s Round using IF, MOD, MROUND and […]

Excel Is Fun

Excel Magic Trick 1192

February 15, 2016 0

Match Lookup Value to Closest Number in 1st Column of Lookup Table DESCRIPTION What to do if you need to match Lookup Value to Closest Number in 1st Column of Lookup Table: (00:10) Problem Set […]

Excel Is Fun

Highline Excel 2013 Class Video 16

February 15, 2015 0

DESCRIPTION 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. […]