Main

If you torture the data enough, it will confess.


You need to round calculations in Excel!

  • Why should you control precision of calculations in a spreadsheet is something that I believe is important. The Excel functions ROUND(), ROUNDUP(), ... are all important elements of building controls. My demonstration of adding 1 + 1 = 3 (as displayed) should be enough of an example to make this point. But I know from experience that the results displayed with formatting are what someone sees, rather than the trailing decimals embedded in a calculation. ... more ... Rounding Formula Results With Excel

Other Excel Pages: Excel References Page, Excel Statistics For Grading, Excel Tips And Tricks, Excel-Data Entry Tip


Backlinks

accommodate changing times, but cling to unchanging principles

former President Jimmy Carter quoting his teacher

Page Views: 1538 | << | Trail Index | >> | HomeLinks