Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up calculation fields in Word with negative numbers?
I am having problems with calculation fields (Word 2000) and calculating
negative numbers. (I am creating a blance sheet with Deposits + and Debits -.) I have a column for Deposits, with a total on the bottom of the page and then a column for Debits with a total on the bottom. I also have a Starting Balance field that adds with the Deposits and subtracts with the Debits to equal a Grand Total. The Grand Total keeps coming up with the Debits + Deposits and then doubling them. Example: Starting balance = $100.00, one line is a deposit of $15.00 (the Grand Total will now show $130.00). Any suggestions??? Thanks in advance. |
#2
|
|||
|
|||
You cannot use the result of one calculation as an input to another
calculation. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Spacie" wrote in message ... I am having problems with calculation fields (Word 2000) and calculating negative numbers. (I am creating a blance sheet with Deposits + and Debits -.) I have a column for Deposits, with a total on the bottom of the page and then a column for Debits with a total on the bottom. I also have a Starting Balance field that adds with the Deposits and subtracts with the Debits to equal a Grand Total. The Grand Total keeps coming up with the Debits + Deposits and then doubling them. Example: Starting balance = $100.00, one line is a deposit of $15.00 (the Grand Total will now show $130.00). Any suggestions??? Thanks in advance. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word2000 letterhead merge | Mailmerge | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
Making Word do something that Wordperfect can do | New Users | |||
WordPerfect keyboard macro>Word equivalent? | New Users | |||
letters - ask/fillin | New Users |