Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell formulas
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two formulas in on cell based on two numbers in another cell? | Excel Discussion (Misc queries) | |||
Carrying formulas over to new cell when old cell is deleted: possi | Excel Worksheet Functions | |||
How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
change cell value greater than another cell value using formulas | Excel Worksheet Functions |