Reply
 
Thread Tools Display Modes
  #1   Report Post  
Ray
 
Posts: n/a
Default Calculation in table

I would like to do some simple calculation in a table. Can someone tell me
how to do it and display corresponding toolbar.

Thanks,

Ray


  #2   Report Post  
Luc
 
Posts: n/a
Default

Ray,
There is no toolbar for calculations.
To us a formula in a table go to Table - Formula - type in your formula
e.g. = C1*(A2+B) hit OK.
In your formula cell you will see the result with a grey background, to see
the formula hit ALT+F9, to update the formula select your cell/table and hit
F9. Also if there are already numbers in your cells Word will automatically
assume you want to make the sum (sum (above), sum (left).
If you want sums only you could also consider using the toolbar Tables and
borders which has an AutoSum button.
Luc
"Ray" schreef in bericht
...
I would like to do some simple calculation in a table. Can someone tell me
how to do it and display corresponding toolbar.

Thanks,

Ray



  #3   Report Post  
Ray
 
Posts: n/a
Default

Luc,

Thanks for your useful information. I now know how to enter formula. I
tried below formula but showed error. Doesn't Word accept such formula?

=IF(SUM(H3)0,SUM(H3),"")

Thanks,

Ray

"Luc" wrote in message
...
Ray,
There is no toolbar for calculations.
To us a formula in a table go to Table - Formula - type in your formula
e.g. = C1*(A2+B) hit OK.
In your formula cell you will see the result with a grey background, to
see the formula hit ALT+F9, to update the formula select your cell/table
and hit F9. Also if there are already numbers in your cells Word will
automatically assume you want to make the sum (sum (above), sum (left).
If you want sums only you could also consider using the toolbar Tables and
borders which has an AutoSum button.
Luc
"Ray" schreef in bericht
...
I would like to do some simple calculation in a table. Can someone tell
me how to do it and display corresponding toolbar.

Thanks,

Ray





  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

The correct syntax is

{ IF { = SUM(H3) } 0 { = SUM(H3) } }

You must use Ctrl+F9 to insert each pair of field delimiters { } and Alt+F9
to toggle off the display of the field code.

--
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
"Ray" wrote in message
...
Luc,

Thanks for your useful information. I now know how to enter formula. I
tried below formula but showed error. Doesn't Word accept such formula?

=IF(SUM(H3)0,SUM(H3),"")

Thanks,

Ray

"Luc" wrote in message
...
Ray,
There is no toolbar for calculations.
To us a formula in a table go to Table - Formula - type in your formula
e.g. = C1*(A2+B) hit OK.
In your formula cell you will see the result with a grey background, to
see the formula hit ALT+F9, to update the formula select your cell/table
and hit F9. Also if there are already numbers in your cells Word will
automatically assume you want to make the sum (sum (above), sum (left).
If you want sums only you could also consider using the toolbar Tables
and borders which has an AutoSum button.
Luc
"Ray" schreef in bericht
...
I would like to do some simple calculation in a table. Can someone tell
me how to do it and display corresponding toolbar.

Thanks,

Ray







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
Table headers/footers and layout Keith Page Layout 1 April 8th 05 07:37 PM
How to Avoid Word 2003 Table Style Problems Judy Haynes Tables 0 March 23rd 05 06:41 PM
Table AutoFormats vs. Table Styles confusion Tony Jollans Tables 5 March 6th 05 07:18 PM
Automatic calculation as data is entered into table cells Gerry Duggan Microsoft Word Help 1 February 23rd 05 10:57 PM
Row height problem with table in table Stephanie T. Tables 0 November 23rd 04 03:35 PM


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