3 Biggest Software Lies:

  • The program's fully tested and bug-free.
  • We're working on the documentation.
  • Of course we can modify it.

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


Projects as Golfing:
You can only hit one ball at a time, so keep each swing focused on where the ball needs to land. If the ball falls short of its destination, you can always hit it again.

D & T 3/30/07


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