Main

The Lime Tree:
Your perception of reality depends on how you choose to view it.

  • Simple abundance, tasty and useful
  • A burden to pick off the ground
D & T 3/30/07

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

Rule #1: Never lose money. Rule #2: Never forget Rule #1.

Warren Buffett

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