Hi Peterkins,
Table cell referencing doesn't work with text strings. To refer to a
character string in a cell, the character string (not the cell itself) must
be individually bookmarked and the bookmark referred to in the reference. So
my previous post on this was wrong (Should have read my own tutorial)!
So, if you bookmark the text range in cell B2 with something like 'Cell2B'
you could use a field coded like:
{IF{Cell2B}= X {=EntryFee*2} \# £,0.00}
Since maintaining the bookmark in such a field can be a PITA, you might find
it easiest to add a FILLIN field to cell B2 and bookmark that. Code the
FILLIN field something like:
{FILLIN "Enter 'X' if accepted"}
Cheers
"Peterkins via OfficeKB.com" u20492@uwe wrote in message
news:5e6c0184d18e9@uwe...
Hi Suzanne
This problem seems to be getting even more bizarre. First if I may
explain I
used the Product function because the Entry Fee can vary from time to
time.
Because I was trying to get this thing working by taking one step at a
time,
I used a fixed fee in the formula, but intended to substitute the result
of
an ASK field into the formula once the formula is made to work properly.
My
main document has two ASK fields one for a date and the other for the
Entry
Fee. As you doubtless know, if the whole document is selected (Ctrl + A)
and
F9 to update, Word displays the prompts for the ASK fields which are then
updated along with the results from the formulae in each of the rows in
Column C.
I used your revised syntax first with the fixed fee and then substituting
the
ASK field { EntryFee } in the formula and got the correct results with
both
versions and using various amounts for fees. However once an update had
produced a value in C, removing the X from Col B and again updating, the
previously calculated value remained in C. I made some further
experiments
and then found that the calculation is performed whether or not there is
an X
in Col B!!
This is how my formula now looks (* = space): - {*IF*B2=X*{*PRODUCT(
{*EntryFee*},2)\#*#0.00*}""*}
What further thoughts do you have please?
With many thanks for your time and patience.
Peter
Suzanne S. Barnhill wrote:
Well, this was pretty bizarre, but here's the answer:
{ IF B2=X { = PRODUCT (2.9,2} "" }
That is, remove the quotes around "X." The spaces around the first = are
crucial, but none of the other spaces matter, and it works with or
without
quotes around the IF field.
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ables/200604/1