Sum formula troubleshooting

QuestionEdit

When I select a cell range and physically type in the Sum formula, the result is rounded up. Example: $1.25 + $1.23 + $3.21 = $5.70 {using " =Sum(cell range selected)" Why does it not calculate actual results? How do I fix this?

AnswerEdit

Kelly, if the cells are not formatted then this should not happen. But still I would suggest you to right click on the cell where you have typed in the SUM formula and select FORMAT CELLS. Im the number tabe select CURRENCY and then select two places of decimal in the DECIMAL box and then click OK. Now you will get the exact result. If you still have any problem you can mail me. Raj