Calculation on Calculation Field

[BobB]

I have a Word form with number fields that I am summing in
a Totals filed. That works great. Now I need to a
budgeted amount from the calculated field but it does not
work. Can I run a calculation on a calculated field?

If not what other options do I have?

Thanks,

 

[Greg Maxey]

Bob,

What doesn't work. Insert another calculation field, in the expressing
window use the cell reference of your first calculation field and the other
operators and variables.

 

[Razvan Popa]

I have about the same situation: I sum 3 number form fields into A, other 3 into B (A and B are of type calculation), then I want C = A + B. C is calculation, formula for it is "=SUM(A,B)", but the result is twice it should be (eg. 1 + 2 yields 6 for me). Can anyone explain this?
Thank you

 

[Razvan Popa]

I use Microsoft Office XP (2002) on Microsoft Windows XP SP1

 

[JGM]

Hi Razvan,

I used to have this problem when I used field bookmarks in my formulas (I
mean the bookmark name from the Bookmark property of the form field property
dialog that you get by double clicking on the field itself while in design
mode).

Now, I always use either absolute cell references
=SUM(A4, B4)
or bookmarks that I insert with the Insert > Bookmark dialog:
=SUM(SUM1, SUM2)
For the latter, make sure that the bookmark you insert includes only the
field itself, and not the cell marker as well, or you will also have the
double or funny/wrong result.

HTH
Cheers!

--
_______________________________________
Jean-Guy Marcil
(e-mail address removed)

I have about the same situation: I sum 3 number form fields into A, other

3 into B (A and B are of type calculation), then I want C = A + B. C is
calculation, formula for it is "=SUM(A,B)", but the result is twice it
should be (eg. 1 + 2 yields 6 for me). Can anyone explain this?

 

[Razvan Popa]

Hi,
I have to bring this up once more:
I tried using absolute cell references, like you said, and I ended up with this:
I have a cell in one of those columns which has a fixed value, 10 (format is: € #,##0.00;(€ #,##0.00) and it displays € 10.00, correct).
Now, when I insert into another cell a value, like 1000, the value in the other cell is € 1,000.00, but the sum of them, which was € 10.00 (correct), is now € 11.00 (wrong, should be € 1010). The formula for the calculation is: =SUM(ABOVE) and it works just fine for numbers < 1000. My language settings for Office XP is English (U.S.).
Later: no, it doesn't do good for, say, 10 and 999.9, the result is € 1,099.00 (!!! :E). 10 and 999 = € 1,009.00, which is good. Also, if I try to insert negative numbers, it adds the absolute value, instead of subtracting it.

The Question:
How can I use Microsoft Word 2002 to make a document template in which I add the values of two columns of fields into two distinct cells, and then add those cells into another one, being able to use numbers >1000 and numbers < 0 in any cell, and get correct results?

I would appreciate any kind of help, including links, advice etc. I RTFH, didn't find my way out of this.

Thank you very much for your time.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Razvan,

Can you send me a copy of your document so that I can be sure that I
understand the problem.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

Hi,
I have to bring this up once more:
I tried using absolute cell references, like you said, and I ended up with this:
I have a cell in one of those columns which has a fixed value, 10 (format

is: ? #,##0.00;(? #,##0.00) and it displays ? 10.00, correct).

Now, when I insert into another cell a value, like 1000, the value in the

other cell is ? 1,000.00, but the sum of them, which was ? 10.00 (correct),
is now ? 11.00 (wrong, should be ? 1010). The formula for the calculation
is: =SUM(ABOVE) and it works just fine for numbers < 1000. My language
settings for Office XP is English (U.S.).

Later: no, it doesn't do good for, say, 10 and 999.9, the result is ?

1,099.00 (!!! :E). 10 and 999 = ? 1,009.00, which is good. Also, if I try to
insert negative numbers, it adds the absolute value, instead of subtracting
it.

The Question:
How can I use Microsoft Word 2002 to make a document template in which I

add the values of two columns of fields into two distinct cells, and then
add those cells into another one, being able to use numbers >1000 and
numbers < 0 in any cell, and get correct results?

I would appreciate any kind of help, including links, advice etc. I RTFH,

didn't find my way out of this.