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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Mitchell - 22 Jun 2007 07:21 GMT

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?

Reply to this Message

Bob Phillips - 22 Jun 2007 09:28 GMT

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

Signature

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.
>
[quoted text clipped - 5 lines]
> 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?

Reply to this Message

Chris Mitchell - 22 Jun 2007 09:43 GMT

Thanks Bob and Scoops, works a treat.

> =A1&" tries hard, but if "&IF(B1="M","he","she")&" tried harder
> "&IF(B1="M","his","her")&" results would be much better"
[quoted text clipped - 8 lines]
>> 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?

Reply to this Message

Scoops - 22 Jun 2007 09:31 GMT

On 22 Jun, 07:21, "Chris Mitchell"
<chris.a.mitch...@NOSPAMbtinternet.com> wrote:

> I have a form that contains NAME in cell A:1, and GENDER in cell B:2.
>
[quoted text clipped - 5 lines]
> 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?

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

Reply to this Message

Chris Mitchell - 22 Jun 2007 09:43 GMT

> On 22 Jun, 07:21, "Chris Mitchell"
> <chris.a.mitch...@NOSPAMbtinternet.com> wrote:
[quoted text clipped - 19 lines]
>
> Steve

Reply to this Message