The generation of random numbers is too important to be left to chance.

Robert R. Coveyou, Oak Ridge National Laboratory

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


A ounce of action is worth a ton of theory.

Friedrich Engels

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