Please can someone tell me what is wrong with the syntax in the following
formula: -

{=IF(B3="X",PRODUCT(2.9,2),"")}

The ’curly brackets’ (braces) were inserted into the cell using Ctrl + F9. I
constructed the formula in the cell originally from the keyboard and got a !
Syntax Error, “ message. I then deleted the formula and constructed the
formula in an Excel worksheet and it worked. I then copied the formula to
the clipboard, went back to the (Word 2000) document table, inserted the
braces into the cell and then pasted the formula between the braces and again
got the same error message as before. Does anyone know the significance of
the double quotes at the end of the message?

From experimenting it seems the problem is to do with the IF condition,
because a straightforward function - PRODUCT(2.9,2) - with appropriate number
formatting gives the correct result i.e. 5.80

To get the job finished I have had to manually update my Form Letter but
would like to get this problem sorted so that I can automate the job next
time I use it.

Peter

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ables/200604/1