Hi Peterkins,
A formula in Column C like:
{IF B2=X {=2*2.9} \# £,0.00}
should give the result you're after. However, this requires hard-coding both
the entry fee and the number of entrants. If you set your table up so that
Column C has the number of entries, and Column D has the fee per entry, you
could use:
{IF B2=X {=C2*D2} \# £,0.00}
in Column E.
For more on Word field maths, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
Cheers
"Peterkins via OfficeKB.com" u20492@uwe wrote in message
news:5e648d56f3b52@uwe...
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