Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
cell addresses and formula?
I have a table in word which has a couple of columns headers "Number of
hours" and "Tuition". I want to use the number of hours * 4.5 to obtain the tuition. I can easily do it in Excel =G4*4.5 but I do not understand how you obtain the proper cell addresses in Word to perform this. The columns are adjacent so is there another way? Thanks for information. Susan www.esill.net |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
cell addresses and formula?
Naming conventions for rows and columns are the same in Word as in Excel,
but the cell addresses can be harder to figure out. To facilitate this, you may want to download the TableCellHelper macro from http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm -- 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. "Susan" wrote in message ... I have a table in word which has a couple of columns headers "Number of hours" and "Tuition". I want to use the number of hours * 4.5 to obtain the tuition. I can easily do it in Excel =G4*4.5 but I do not understand how you obtain the proper cell addresses in Word to perform this. The columns are adjacent so is there another way? Thanks for information. Susan www.esill.net |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
cell addresses and formula?
Thank you Suzanne, but now I am having syntax errors.
I tried the =G:7*4.5 and {=G:7*4.5} but that did not work. How do you perform the calculation for G:7 * 4.5? I am beginning to think I should convert the document to Excel. "Suzanne S. Barnhill" wrote in message ... Naming conventions for rows and columns are the same in Word as in Excel, but the cell addresses can be harder to figure out. To facilitate this, you may want to download the TableCellHelper macro from http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm -- 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. "Susan" wrote in message ... I have a table in word which has a couple of columns headers "Number of hours" and "Tuition". I want to use the number of hours * 4.5 to obtain the tuition. I can easily do it in Excel =G4*4.5 but I do not understand how you obtain the proper cell addresses in Word to perform this. The columns are adjacent so is there another way? Thanks for information. Susan www.esill.net |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
cell addresses and formula?
I figured it out, macro shows G:7 but really is G7 address. Guess you
cannot copy formula to columns then like in Excel? "Susan" wrote in message ... Thank you Suzanne, but now I am having syntax errors. I tried the =G:7*4.5 and {=G:7*4.5} but that did not work. How do you perform the calculation for G:7 * 4.5? I am beginning to think I should convert the document to Excel. "Suzanne S. Barnhill" wrote in message ... Naming conventions for rows and columns are the same in Word as in Excel, but the cell addresses can be harder to figure out. To facilitate this, you may want to download the TableCellHelper macro from http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm -- 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. "Susan" wrote in message ... I have a table in word which has a couple of columns headers "Number of hours" and "Tuition". I want to use the number of hours * 4.5 to obtain the tuition. I can easily do it in Excel =G4*4.5 but I do not understand how you obtain the proper cell addresses in Word to perform this. The columns are adjacent so is there another way? Thanks for information. Susan www.esill.net |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
cell addresses and formula?
All cell addresses in Word are absolute, so no, you can't copy them to other
cells without modification. If you need to do a lot of such calculations, it might be more efficient to embed an Excel sheet in the Word doc. -- 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. "Susan" wrote in message ... I figured it out, macro shows G:7 but really is G7 address. Guess you cannot copy formula to columns then like in Excel? "Susan" wrote in message ... Thank you Suzanne, but now I am having syntax errors. I tried the =G:7*4.5 and {=G:7*4.5} but that did not work. How do you perform the calculation for G:7 * 4.5? I am beginning to think I should convert the document to Excel. "Suzanne S. Barnhill" wrote in message ... Naming conventions for rows and columns are the same in Word as in Excel, but the cell addresses can be harder to figure out. To facilitate this, you may want to download the TableCellHelper macro from http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm -- 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. "Susan" wrote in message ... I have a table in word which has a couple of columns headers "Number of hours" and "Tuition". I want to use the number of hours * 4.5 to obtain the tuition. I can easily do it in Excel =G4*4.5 but I do not understand how you obtain the proper cell addresses in Word to perform this. The columns are adjacent so is there another way? Thanks for information. Susan www.esill.net |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to enter cell references in a table | Tables | |||
I need to modify a formular... | Microsoft Word Help | |||
Cell addresses in a Word Table | Tables | |||
How to merge without addresses ? | Mailmerge |