Sum formula troubleshooting

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:56 PM GMT

Question

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?

Answer

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

Advertisement

©2021 eLuminary LLC. All rights reserved.