Quote:
Originally Posted by ALEX T
i am a basic user. i have used excel for a long time but basically self-taught.
i am an accountant and i can't have cells not adding up exactly. so when i put in cell A1 times 7% sales tax for each month and then add the column up it doesn't add up to the numbers in the column because the individual cells have been rounded to dollars and cents. i know there is a way to only use the value that appears in the cell to get a total but i can't seem to find it. can someone give me the procedure.
this would be a great help,
thanks in advance
|
when you mutiply a cell by another it stores the calculated value which may differ from the displayed value. e. g 7.21 times 7% (0.07) = .5047 which displays as .50 in dollar format but adds .5047. to get around this use the following formula =round(cell1*.07,2) This will save in the cell only the two digits to the right of the decimal point or .50. to save whole numbers change the formula to =round(cell1*.07,0)