Hello,

Using Excel 2007: I have a spreadsheet that is calculating several formulas and placing the sum in specific cells. This works well, except; because of the extensive calculations, there are sometimes 15-25 numbers after the decimal. For example, in some cases, the sum displays as 25.3654896523658

I know that I can FORMAT the cell to display a specified number of decimals, however, how do I format the FORMULA to only calculate to TWO decimals. In other words, how do I direct the formula to round off to two decimals in the sum so the above example would read 25.36 in the formula bar.

Thank you in advance for the input.

-Chris