Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Why is calculation wrong?
I have a simple list of dollar amounts ($ 100) in a table. No empty boxes.
One debit--entered ($ 175). The sum is wrong. Can't figure out why! Please help!! Thank you |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Why is calculation wrong?
BandTreasurer wrote:
I have a simple list of dollar amounts ($ 100) in a table. No empty boxes. One debit--entered ($ 175). The sum is wrong. Can't figure out why! Please help!! Thank you A little more information about your table and it's contents might help us answer your inquiry. Are you attempting an accounting like function like a balance sheet or check book reconciliation? Have you done any online searches for templates? Are you putting the debit(s) in the same column with the other dollar amounts (credits?)? While we don't need the specific dollar amounts, what are the contents of the other cells? Does the amount of the "error" have any recognizable mathematical relationship to the debit, like being twice the amount? If so, perhaps debits require a minus sign. As an alternate, perhaps you need a cell with the total of the other cells, then subtract the debit from that total. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Why is calculation wrong?
Hi BandTreasurer,
Are you using formfields in a protected document to hold the values, or simply values input into a table in an unprotected document? What is your formula? -- Cheers macropod [MVP - Microsoft Word] "BandTreasurer" wrote in message ... I have a simple list of dollar amounts ($ 100) in a table. No empty boxes. One debit--entered ($ 175). The sum is wrong. Can't figure out why! Please help!! Thank you |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Footnotes have the wrong numbers and are put on the wrong page | Microsoft Word Help | |||
Calculation in a table | Microsoft Word Help | |||
Calculation | Tables | |||
Calculation | Tables | |||
Subtraction Calculation | Tables |