If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MS Word Table Formulas??
i have a simple table in ms word 2000. i need to subtract cell F2 from Cell
E2 and have the answer show up with a dollar sign as well. i can't seem to perform this in ms word. any help on this would very much be appreciated |
#2
|
|||
|
|||
MS Word Table Formulas??
Try the formula field
{ =(e2-f2) \# $,#.00 } where the field delimiters { } are entered with CTRL+F9. -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. jaccs89 wrote: i have a simple table in ms word 2000. i need to subtract cell F2 from Cell E2 and have the answer show up with a dollar sign as well. i can't seem to perform this in ms word. any help on this would very much be appreciated |
#3
|
|||
|
|||
MS Word Table Formulas??
In the cell where you want the result to appear, enter
{ = E2 - F2 \# "$,0.00$,0.00)" } Where the { } are inserted by using Ctrl+F9, Alt+F9 is used to toggle off the display of field codes and F9 is used to update the field so that it shows the result of the calculation. -- 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 "jaccs89" wrote in message ... i have a simple table in ms word 2000. i need to subtract cell F2 from Cell E2 and have the answer show up with a dollar sign as well. i can't seem to perform this in ms word. any help on this would very much be appreciated |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can Wordperfect templates be converted to Word template docs | Terrill | New Users | 2 | September 14th, 2005 09:14 PM |
Boiletplates from Word Perfect | linda | General Discussion | 1 | January 28th, 2005 05:37 PM |
Continuous breaks convert to next page breaks | Jennifer Hunt | General Discussion | 2 | December 30th, 2004 05:45 PM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
word error | mac | General Discussions | 1 | May 6th, 2004 08:14 AM |