Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
FORMULAS IN TABLES
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. |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
FORMULAS IN TABLES
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. 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
FORMULAS IN TABLES
In addition to Stan's advice, I would also suggest using the Excel
newsgroups for Excel questions. -- JoAnn Paules MVP Microsoft [Publisher] "Stan Brown" wrote in message t... 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. 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
FORMULAS IN TABLES
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 |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
FORMULAS IN TABLES
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Stan Brown" wrote in message t... 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. 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
FORMULAS IN TABLES
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. "Stan Brown" wrote: 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. 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. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
FORMULAS IN TABLES
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. "Karen" wrote: 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with formulas in Word tables - calculating time on scene. | Tables | |||
Changing format of multiple pre-created tables | Microsoft Word Help | |||
Formulas in Word Tables | New Users | |||
When joining tables, table sections shift left or right. | Tables | |||
Is there a way to "join" tables in Word 2003? | Tables |