### Excel 2013 Preview #3: FLOOR.MATH & CEILING.MATH: Round To Significance Excel Magic Trick 951

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htmSee how the use the new FLOOR and CEILING functions:1. FLOOR.MATHa. Round down to a significanceb. Significance argument is optional and the default is 1c. Mode argument is options (rounds negative numbers away from zero), but if you put -1 or any negative number it will round negative numbers toward zero.2. CEILING.MATHa. Round up to a significanceb. Significance argument is optional and the default is 1c. Mode argument is options (rounds negative numbers toward zero), but if you put -1 or any negative number it will round negative numbers away from zero.

Length:
03:09