Reply
 
Thread Tools Display Modes
  #1   Report Post  
Spacie
 
Posts: n/a
Default 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   Report Post  
Doug Robbins
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word2000 letterhead merge BAW Mailmerge 3 June 25th 05 01:17 PM
Underscore (_) will not always display in RTF files (Word 2002). David A Edge Microsoft Word Help 6 June 14th 05 10:39 AM
Making Word do something that Wordperfect can do NarniaUK New Users 4 May 1st 05 10:44 PM
WordPerfect keyboard macro>Word equivalent? Anty New Users 2 March 13th 05 06:23 PM
letters - ask/fillin Caroline H New Users 2 February 25th 05 08:19 PM


All times are GMT +1. The time now is 12:27 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"