Always round formula results

Item# DA1009

Product Description

Always round calculations results. You will never (or at least it will be extremely difficult) to tie out or reconcile among schedules or analysis totals. It gives you control over number of digits you want to round to.

To round, all of your calculations should be included in the "Round" functions =round(number,num_digits). For example, look at the example below.

Round function in excel spreadsheet

Also, I am using round function when I need to show number rounded to thousands:

Round function in excel spreadsheet

This is especially usuful in budget development.

ExcelIdea.com offers consulting services in creating custom solutions or upgrading your existing company spreadsheets. No request is too big or too small. Learn more .

My Blog