Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.tables
|
|||
|
|||
![]()
The Word Help topics "Referencing cells in a table" and "Perform
calculations in a table" would probably be helpful to you as well. -- 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. "Rosy3392" wrote in message ... HELLO!!! WOW! IT TOOK ME A WHILE BUT I FINALLY FIGURED IT OUT!!!!!! YES YOUR POST WAS HELPFUL, BUT I DIDN'T KNOW THAT FOR EVERY "NEW" TABLE THAT IS INSERTED ON THE WORD DOCUMENT IT STARTS ALL OVER AGAIN!!! FOR INSTANCE... YOU OPEN A NEW TABLE WITH 3 ROWS AND 5 COLUMNS... YOU WANT TO ADD TITLES TO THE FIRST ROW TO IDENTIFY THE COLUMN BELOW... OK.... THE TITLES AND DATA WOULD BE LIKE: (NOTE: A, B, C, D, E, 1, 2, 3, 4 are not included in the table. This is when you start a ne table in Word, or when you open a form to fill out and want to creat a formula A, B, C, D, 1, 2, 3, 4 ARE NOT THERE TO HELP YOU IN WORD THOUGH I just created it to direct you on what I am trying to explain) this is: A B C D E 1 QTY ITEM # DESCRIPTION UNIT PRICE TOTAL LINE 2 3600 .43 $1,548.00 3 4 To get the "TOTAL LINE" I would imagine "QTY" is A1 so I would put a formula of =A2*D2 this formula can be inserted by going to the tabs above and selecting "Layout" it's the last option. Well, now that I know what to do, I wanted to share it with everyone that was having trouble. :-) Hopefully it's helpful. "Tom Conrad" wrote: When using formulas in a word table the cell numbering scheme is the same as excel. A1, A2, B4, etc. If you have merged cells you may have to experiment to discover the correct columnRow reference. -- Tom Conrad "Rosy3392" wrote: Hello, I was doing a form for my business, and I wanted it to insert formulas in the cells that the form provided, but I don't know how to differ one cell from the other since they are not lableled like Excel. When I choose "Formula" in the top tabs, it opens a window to insert the formula, but how can I do this if the cells are not labeled? I wanted to multiply "Qty." by "Unit Price" and then get the results in the "Line Total" area with the formula in that cell. Any suggestions?? I know I should use Excel, but the paper layout of Word is way better than Excel's. I know how to use Excel, but again... Word is much more organized "Print wise" than Excel. Thank you! |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
i need a invoice for a labour minus tax invoice | Microsoft Word Help | |||
How to change to default font from Asian input to Latin input? | Microsoft Word Help | |||
how do i change fields in sales invoice/word | Microsoft Word Help | |||
Why will the invoice not print, only the word invoice | Microsoft Word Help | |||
Invoice Template with Autoupdate for Invoice Number | Microsoft Word Help |