# How to insert line of text on other worksheet depending upon result in a cell?

1. ## How to insert line of text on other worksheet depending upon result in a cell?

Hi there,

I have asked this question before but was hoping I might be able to achieve
this by using a formula without a macro being involved!

I have a spreadsheet made up of 5 worksheets and I would like to insert a
line of text on the worksheet called Percentages if a specific condition is
met on another worksheet called Other.

For example on Other I currently have a Data Validation box in E34 where I
can choose Y, N or N/A and depending upon the result enters a 1 in the
adjacent cell F34 or leaves it blank.

That current formula on Other is =IF(E34="Y",1,"") which works as expected.

I would however like to insert a line of text 'Training Issue' into the
Percentages worksheet at say I41 if Y is selected in Other E34

I have tried entering the following formula in Percentages I41 but it
doesn't work - obviously my logic is flawed.

=IF(Other!E34=0,"",(IF(Other!E34=Y,"Training Issue"))

That is the best I can come up with and it is obviously wrong so can some

--
-=pp=-

2. =IF(Other!E34=0,"",IF(Other!E34="Y","Training Issue",""))

3. ## Re: How to insert line of text on other worksheet depending upon result in a cell?

Hi

Try this:
=IF(Other!E34="Y","Training Issue","")

Andy.

"Pheasant PluckerŪ" <pheasant@plucker.not> wrote in message
news:eKHnJYBTGHA.5116@TK2MSFTNGP14.phx.gbl...
> Hi there,
>
> I have asked this question before but was hoping I might be able to
> achieve
> this by using a formula without a macro being involved!
>
> I have a spreadsheet made up of 5 worksheets and I would like to insert a
> line of text on the worksheet called Percentages if a specific condition
> is
> met on another worksheet called Other.
>
> For example on Other I currently have a Data Validation box in E34 where I
> can choose Y, N or N/A and depending upon the result enters a 1 in the
> adjacent cell F34 or leaves it blank.
>
> That current formula on Other is =IF(E34="Y",1,"") which works as
> expected.
>
> I would however like to insert a line of text 'Training Issue' into the
> Percentages worksheet at say I41 if Y is selected in Other E34
>
> I have tried entering the following formula in Percentages I41 but it
> doesn't work - obviously my logic is flawed.
>
> =IF(Other!E34=0,"",(IF(Other!E34=Y,"Training Issue"))
>
> That is the best I can come up with and it is obviously wrong so can some
>
> --
> Thanks in advance & regards,
> -=pp=-
>
>

4. ## Re: How to insert line of text on other worksheet depending upon result in a cell?

Thanks guys...works a treat!

At the risk of embarrassing myself when I tried either of them they wouldn't
work at first...

Only later did I discover that the font was set to white - the result was
there all the time but I just couldn't see it!

Thanks & regards,
-=pp=-

<Andy> wrote in message news:eM80UmBTGHA.2276@tk2msftngp13.phx.gbl...
> Hi
>
> Try this:
> =IF(Other!E34="Y","Training Issue","")
>
> Andy.
>
>
> "Pheasant PluckerŪ" <pheasant@plucker.not> wrote in message
> news:eKHnJYBTGHA.5116@TK2MSFTNGP14.phx.gbl...
> > Hi there,
> >
> > I have asked this question before but was hoping I might be able to
> > achieve
> > this by using a formula without a macro being involved!
> >
> > I have a spreadsheet made up of 5 worksheets and I would like to insert

a
> > line of text on the worksheet called Percentages if a specific condition
> > is
> > met on another worksheet called Other.
> >
> > For example on Other I currently have a Data Validation box in E34 where

I
> > can choose Y, N or N/A and depending upon the result enters a 1 in the
> > adjacent cell F34 or leaves it blank.
> >
> > That current formula on Other is =IF(E34="Y",1,"") which works as
> > expected.
> >
> > I would however like to insert a line of text 'Training Issue' into the
> > Percentages worksheet at say I41 if Y is selected in Other E34
> >
> > I have tried entering the following formula in Percentages I41 but it
> > doesn't work - obviously my logic is flawed.
> >
> > =IF(Other!E34=0,"",(IF(Other!E34=Y,"Training Issue"))
> >
> > That is the best I can come up with and it is obviously wrong so can

some
> > kind soul help please?
> >
> > --
> > Thanks in advance & regards,
> > -=pp=-
> >
> >

>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1