Using If Field in tables

[Gary Thornton]

Can the If Field in a table display specific information based upon data in another cell?

My Microsoft Word document includes a table. In column 2 the user will either enter a “1†or leave it blank. When column 2 contains “1â€, I want “EA†to display in column 3 and a specified amount in column 8. If column 1 is blank, then I want columns 3 and 8 to be blank.

In column 3 I have entered { If b2 = 1 “EA†“†}. Every combination of spaces, parentheses, quotes, commas and semi colons that I could think of produce the same result for both “blank†and for “1â€. Sometimes I get “EA†and sometimes I get “blank†and sometimes I get “1†or “,â€. But none of the combinations produce one result for “1†and another for “blankâ€

Where have I gone wrong? Or, do I need to use a macro or VBA to solve this problem

Thanks for any help
Gar

PS: This is my first post to anything like this. If I have made any mistakes, please tell me.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Use { IF { = B2 } = 1 "EA" }

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP