How do I include cell contents from a form in generic statements/strings within the form?

  • Thread starter Thread starter Chris Mitchell
  • Start date Start date
C

Chris Mitchell

I have a form that contains NAME in cell A:1, and GENDER in cell B:2.

I want to build a library of generic statements along the lines of:

NAME tries hard, but if HE/SHE tried harder HIS/HER results would be much
better.

How can I make these statements get NAME from A:1, and derive HE or SHE and
HIS or HER from GENDER in B:2?
 
=A1&" tries hard, but if "&IF(B1="M","he","she")&" tried harder
"&IF(B1="M","his","her")&" results would be much better"

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
I have a form that contains NAME in cell A:1, and GENDER in cell B:2.

I want to build a library of generic statements along the lines of:

NAME tries hard, but if HE/SHE tried harder HIS/HER results would be much
better.

How can I make these statements get NAME from A:1, and derive HE or SHE and
HIS or HER from GENDER in B:2?
Click to expand...

Hi Chris

Try something along the lines of:

=A1&" tries hard but if "&IF(B2="M","he","she")&" tried harder
"&If(B2="M","his","her")&" results would be much better."

Regards

Steve
 
Thanks Bob and Scoops, works a treat.
Bob Phillips said:
=A1&" tries hard, but if "&IF(B1="M","he","she")&" tried harder
"&IF(B1="M","his","her")&" results would be much better"

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)
Click to expand...
 
Thanks Bob and Scoops, works a treat.
Scoops said:
Hi Chris

Try something along the lines of:

=A1&" tries hard but if "&IF(B2="M","he","she")&" tried harder
"&If(B2="M","his","her")&" results would be much better."

Regards

Steve
Click to expand...
 
Back
Top