Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Formula in a Word Table with chars in the cell
I am trying to put a formula in a word table similar to below but I keep
getting syntax error =IF(b2="Y",50,0) Is it that you cant use characters in a formula in word, I know I can do it in excel but cant seem to master it in word. I would be grateful if anyone has any ideas |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Formula in a Word Table with chars in the cell
Hi Mac,
You can use characters in Word formulae, but not with the syntax you've used, and not with cell referencing. If you bookmark the *contents* of cell B2, not the cell itself, you could use a field coded like: {IF{BkMrk}= Y 50 0} where 'BkMrk' is the name of your bookmark and the field braces (ie '{ }') are created in pairs via Ctrl-F9. If you need to handle the possibility that the 'Y' might be entered as 'y', you could use: {IF{BkMrk \* Caps}= Y 50 0} Cheers "Mac" wrote in message ... I am trying to put a formula in a word table similar to below but I keep getting syntax error =IF(b2="Y",50,0) Is it that you cant use characters in a formula in word, I know I can do it in excel but cant seem to master it in word. I would be grateful if anyone has any ideas |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reveal codes in a word document | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Converting Word Perfect forms to Word forms | Microsoft Word Help | |||
How can Word display full path of a file in the title bar? | Microsoft Word Help | |||
Word 2003 Table cell formula | Tables |