Conditional Results Based on Another Cell's Content

[Mark Collins]

I need help with using one cell's contents to determine
the input for another cell in generating loan documents.

In my table I use A1 to retain information that tells me
if the loan I am working with is joint (contains an X if
joint, null if not joint). If it is joint, I want another
cell to contain a IF THEN function to display a date next
to the co-borrower's signature line. If not I want the
cell to remain blank.

Please e-mail to me at (e-mail address removed) a copy of
your reply if possible.

Thanks,

Mark

 

[Peter Hewett]

Hi Mark

Insert this nested field in the table cell you want the date to appear. This
example presumes your "X" is going in table cell A1:

{If A1 <> "" {Date} "" \* Mergeformat}

In fact if you do anything anything other that leave cell A1 blank then the
date appears. You can press Ctrl+F9 to create an empty field at the insertion
point. To to create a field around selected text.

HTH + Cheers - Peter

 

[Peter Hewett]

Hi Mark

Sorry please ignoire my previous post as it's not going to work. That'll
teach me to try it first! The problem is, is that the cell reference A1
always returns a numeric value! So you can't test for X.

Although you can use a bookmark reference, I don't recommend it as typing
over the bookmark as you know deletes it!

If you don't get a "real" answer from someone else I'll think about it.

Sorry about that - Peter

 

[Jean-Guy Marcil]

Hi Mark,

If you can live with a "1" instead of a "x" to indicate "jointness", then
you can try this:

{If {=SUM(A1) \# "0"}= 1 {DATE} ""}

--
Cheers!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Mark,

If you were using formfields in the table, you could use

{ IF { REF Text1 } = X { DATE } }

where Text1 is the bookmark that is assigned to the formfield in which you
would enter the X if it applied. This does required that the document be
protected for forms, but that may not be a problem for what you are working
with. See:

Please Fill Out This Form
Part 1: Create professional looking forms in Word
http://www.computorcompanion.com/LPMArticle.asp?ID=22

Part 2: Adding Automation to your Word forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=46

Part 3: Learn more VBA (macros) to automate your forms.
http://www.computorcompanion.com/LPMArticle.asp?ID=119

Part 4: Use custom dialog boxes in your Word forms
http://www.computorcompanion.com/LPMArticle.asp?ID=127

Part 5: Connect your AutoForm to a database to save input time and keep
better records!
http://www.computorcompanion.com/LPMArticle.asp?ID=136


--
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

 

[mc]

Doug,

I like your suggestion but I don't think I can protect
for form fields. The software reading the DOC from as an
AutoWord MFC Application and I can't reproduce the
environment from this computer (it worked great on my
computer when protected). I will try it when I get to the
office.

For anyone using this solution it helps to check the
field property for "calculate on exit" in the form field
properties window. This will automatically update the
desired field.

Mark

 

[mc]

Jean,

The X comes from an AutoWord MFC Application and I can't
alter the data source. I think the way to try is with the
REF solution that Doug offered. Will post my results
after I try it from the office.

Thanks for your reply.

Mark