+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Pheasant Plucker®
    Guest

    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
    kind soul help please?

    --
    Thanks in advance & regards,
    -=pp=-



  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,143
    =IF(Other!E34=0,"",IF(Other!E34="Y","Training Issue",""))

  3. #3
    Guest

    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
    > kind soul help please?
    >
    > --
    > Thanks in advance & regards,
    > -=pp=-
    >
    >




  4. #4
    Pheasant Plucker®
    Guest

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

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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