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