30 articles Excel 2007 Page 2 / 3

How to fix rounding errors in Excel? These errors are messing up calculation checks.

Sometimes Excel does not calculate numbers correctly and gives an “incorrect” result. Avoiding technical jargon, its basically because Excel rounds of the results of its calculation. This typically isn’t a problem because most users will not need the 10th decimal place, and would never notice the problem. However, the problem is quite noticeable for those who are doing…

Conditional Formatting for Multiple Cells – Quick Memory Aid

This article is not for beginners, but serves as a memory aid for conditional formatting driven by formulas. For the basic stuff, go to http://www.contextures.com/xlcondFormat01.html For some examples of using conditional formatting, go to Excel: Alternate Row Colors / Color Banding, Column Colors and Checker Patterns In the conditional format, the formula will work as long as it returns…