formula in word

[Cheri]

I have an invoice and would like to add the column of charges and subtract
the column of credits and have just that total in one particular cell. How
do I do that.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Q2hlcmk=?=,

I have an invoice and would like to add the column of charges and subtract
the column of credits and have just that total in one particular cell.

This is in Word? Have you looked at the Table/Formula command? Starting with
Sum(Above) and working from there...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[Andrea Jones]

To do calculations which do not just use the cells above you need to imagine
your table cells labelled as they would be in Excel i.e. Columns A, B, C, etc
rows 1, 2, 3. You can then do things like =(C2+C3)*C4 in the Tables ->
Formula window to get the answer you require.

 

[Cheri]

I've tried that but I get a syntax error. I want to add the charges in
Column C(which has lines 1-7) and subtract any credits that appear in Column
D - lines 1-7) all into a cell at the bottom of Column D - i.e. D10

 

[Andrea Jones]

You should be able to click in D10, click on Tables ->Formulas and then type

=SUM(C1:C7)-SUM(D17)

Make sure you start the calculation with = or it won't work.

 

[Cheri]

Tried that and it puts in a number but it's not the right number. More
suggestions?

 

[Doug Robbins]

What are the numbers in Cells C1-C7 and D1-D7 and what is the result
showing? Are the numbers in D1-D7
the result of a formula?
--
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

 

[Mike Faulkner]

Cheri

Place cursor in a cell where you want the result displayed. Press [Alt+F9].
This will insert a set of curly brackets. In between the curly brackets type
your formula.
ie. "=(a1:e1)" or "=sum(a1:e1)-sum(a2:e2)". When done right click field and
click on 'Update Field'.

Regards
Mike

PS. Inverted commas are used for indicating formulae etc. Don't use in
formula.

 

[Doug Robbins]

Ctrl+F9, not Alt+F9

--
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

Cheri

Place cursor in a cell where you want the result displayed. Press
[Alt+F9].
This will insert a set of curly brackets. In between the curly brackets
type
your formula.
ie. "=(a1:e1)" or "=sum(a1:e1)-sum(a2:e2)". When done right click field
and
click on 'Update Field'.

Regards
Mike

PS. Inverted commas are used for indicating formulae etc. Don't use in
formula.

What are the numbers in Cells C1-C7 and D1-D7 and what is the result
showing? Are the numbers in D1-D7
the result of a formula?
--
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