Reply
 
Thread Tools Display Modes
  #1   Report Post  
SaraWitch SaraWitch is offline
Junior Member
 
Posts: 0
Default Text Form Field Calculation

Hello all,

I have a budget form where I want to calculate the expenditure and income, with a total of what's left. I have set up text form fields (E1 to E38 for expenditure which is on the first page and I1 to I8 which is on the second page), but they are not calculating. I have calculated on exit and have the following formulas in the Expression boxes:

Page 1 - E1 to E38

Page 2 - I1 to I8

Page 2 - Incoming (Expression =Sum(E1:E38))
Outgoing (Expression =Sum(I1:I8))
Total (Expression =Incoming-Outgoing))

I hope this makes sense! And I can't work out why it's not working! Any help would be greatly appreciated!

Ta muchly, folks!
  #2   Report Post  
SaraWitch SaraWitch is offline
Junior Member
 
Posts: 0
Default

Okay, so I have been playing and have changed I1, etc, to Income1 and calculated as =Sum(Income1,Income2,Income3, etc...). However, as I have quite a few in Expenditure, is there a quick way of adding many fields, rather than typing them all out?
  #3   Report Post  
SaraWitch SaraWitch is offline
Junior Member
 
Posts: 0
Unhappy

So I have gone through all the expenditure and change these to Exp1, etc., but now the total isn't working! Incoming is correctly calculating as £38, Expenditure as £8, but the total is showing as £60, not £30!
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
Text Form Field Calculation in a Protected Document elinhaw Tables 3 December 22nd 09 06:09 PM
Creating a date calculation with a text form field LC Young Microsoft Word Help 2 September 28th 09 12:08 AM
Calculation in form field Keep It Simple Stupid Tables 1 September 6th 07 12:04 AM
Text Form Field Calculation JohnS Microsoft Word Help 5 December 21st 06 02:16 AM
Calculation form field won't update Impecunious Microsoft Word Help 8 November 27th 06 04:09 PM


All times are GMT +1. The time now is 02:41 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"