Hi Suzanne
Thanks for your response. If one tries to construct the formula from the
Word menu bar - Table Formula, the Formula dialogue appears and any formula
constructed appears in the cell with a pair of braces around it. However if
one pastes the IF function into the formula line it then appears as "=IF( )"
(without the quotes of course). I have been unable to find any way to insert
a pair of braces in the formula line. So I have constructed the formula
directly in the table cell using Ctrl + F9 to insert the braces then keying
in your suggested syntax. The formula was accepted into the cell without any
error message, but when I selected the cell and updated it with F9 the cell
remained blank even though there was an X in B3. Your alternative also
performed similarly.
It seems the inclusion of spaces does make a difference. In the following I
have put asterisks where spaces occur: -
{*IF*B2*=*"X"*{*=*PRODUCT(2.9,2),*}""*} This gives a "no result" i.e. the
cell is blank when updated.
{*IF*B2="X"*{*=*PRODUCT(2.9,2),*}""*} Removing the spaces either side of the
first "=" causes a X to appear in the cell when it is updated.
Unfortunately I am no further forward in finding what is wrong with the
syntax of my version. Please may I ask you if you have actually tried to get
this working on your system; I would be very interested to know.
Suzanne S. Barnhill wrote:
I think you're trying to use Excel syntax in Word. Word's syntax would be:
{ IF B3 = "X" { = PRODUCT (2.9,2) } "" }
or just
{ IF B3 = "X" { = 2.9 * 2 } "" }
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ables/200604/1