FORMULAS IN TABLES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IM EXPERIMENTING WITH TABLE FORMULAS. TO ADD CELL VALUES YOU USE =SUM(C2,C3)
FOR EXAMPLE, BUT HOW WOULD YOU SUBTRACT ONE CELL VALUE FROM THE OTHER.
 
Sun, 19 Feb 2006 05:56:27 -0800 from STOBBSNET1 <STOBBSNET1
@discussions.microsoft.com>:
IM EXPERIMENTING WITH TABLE FORMULAS. TO ADD CELL VALUES YOU USE =SUM(C2,C3)
FOR EXAMPLE, BUT HOW WOULD YOU SUBTRACT ONE CELL VALUE FROM THE OTHER.
Click to expand...

Stop shouting, please. Use standard English and you're more likely to
get helpful answers.

I assume you're asking about Excel. You can do normal-type
arithmetic:

=c1+c3
=c1-c3
=c1*c3
=c1/c3
=a1+b2-c3*d4/e5

I would tell you to read about formulas in Excel Help, but a usual
I'm completely unable to find any sort of useful information. When I
search "formula" I get lots of hits, but _none_ of them tells how to
construct a formula. "formula overview" gets different hits, but
again not one of them is helpful.

I have never seen help files as bad as those in Office 2003.
 
In addition to Stan's advice, I would also suggest using the Excel
newsgroups for Excel questions.
 
Hi Stobbsnet1,

In addition to what Stan suggested, if you're using a Word (2003)
table, you can also format its cells in the same way. The only thing
is that the Word table won't show you the column and row
identifications as it does in Excel.

So if you wanted to format a cell in a Word table to have a formula,
you would select it, go to TABLE, Formula, and type say: =A1-B1,
select your numbering style, and click OK.

If you have a really huge table of numbers though, I would likely do it
in Excel first and then embed or link it into your Word document.

Good luck with this!
Karen
 
Since the OP has posted this in a Word NG and refers to "tables," it is
perverse to assume he/she is asking about Excel. Actually Word 2003 Help is
quite helpful about this. You can start with the Help topic "Perform
calculations in a table" and add "Referencing cells in a table." The topic
"Field codes: = (Formula) field" provides comprehensive information on
operators, functions, switches, table references, etc. All of those topics
are among the first few hits in a search for "formulas in tables" or
"calculation in tables." The formulas you provide for Excel will work in
Word as well, but they must be stated as a field, such as { =c1+c3 }.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
Sorry about the shouting Stan. Im new to this forum thing. Thanks for your
advice. It was word i was using but the formulas used in excel also work in
word.
 
Thanks very much karen that was a great help. I have another problem with the
same table. in my table for example c3=c1+c2, d3=d1+d2 and so on. im altering
the amounts in columns 1 and 2 thus changing the amounts in column 3. in
column 3 i would like the amounts to be displayed in descending order down
the rows as the values change. is it possible to do this. hope that made
sense.
 
Back
Top