Problem with "IF" in online form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on an online form in Word 2002 that has a table with various
cells that receive either an "X" or are left blank depending upon the value
selected from a dropdown field (which is set to calculate on exit). I have
created a formula for each cell of the grid that looks something like this: {
IF Dropdown1 = "Red" "X" "" }. The problem that I have is that the formula
always displays the result for false (ie, ""), no matter what value is
selected from the dropdown field.

Any ideas as to what I am doing wrong?
 
Cave

Yes. You need to put the Dropdown1 in a REF field.

{IF{Dropdown1}="Red""X"""}

remember, but pairs of field code braces { } need to be created with
CTRL+F9.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using FILLIN with IF Field 1
Calculate results of dropdown boxes in table 11
Why isn’t this macro working? 3
Using form text fields included in an IF Statement with autotext 7
Table with a Calculation Field and Dropdowns 2
Conditional Formatting and dropdowns 3
Populating and "IF" field from a drop-down list 0
Change text based on drop down list entry 2

Back
Top