+ Reply to Thread
Results 1 to 5 of 5

If function that returns value in a cell.

  1. #1
    rayteach
    Guest

    If function that returns value in a cell.

    I want to make an IF function that refers to a cell in another worksheet and
    returns the value in that cell. All but the TRUE condition would be
    =if(cell>0,,""} … In other words, if the referenced cell has data in it, I
    want whatever data is there to be the result of the formula. How do I do this?
    --
    ray

  2. #2
    Ragdyer
    Guest

    Re: If function that returns value in a cell.

    Let XL do the work for you.

    Open both WBs.

    Start your formula:
    =IF(
    Then navigate to the other WB, and click in the cell that you wish to
    lookup.

    XL will add the path to your formula.
    Then, in the formula bar, add
    >0,

    OR
    <>"",

    Then click in the cell *again* to repeat the path for the "True" condition.
    End off by adding the "False" condition to the formula bar
    ,"")
    OR
    ,"No Data")

    Then hit <Enter>.

    Your formula might look something like this:

    =IF(Sheet3!A1<>"",Sheet3!A1,"No Data")
    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------

    "rayteach" <rayteach@discussions.microsoft.com> wrote in message
    news:309B3F75-5D20-426E-9815-6ADCBA6B091B@microsoft.com...
    > I want to make an IF function that refers to a cell in another worksheet

    and
    > returns the value in that cell. All but the TRUE condition would be
    > =if(cell>0,,""} … In other words, if the referenced cell has data in it, I
    > want whatever data is there to be the result of the formula. How do I do

    this?
    > --
    > ray



  3. #3
    Ragdyer
    Guest

    Re: If function that returns value in a cell.

    BTW,

    You'll notice that when the Source WB is closed, the path in the formula
    might expand "greatly", depending on just exactly where (File, Folder,
    Directory, Drive) the Source WB is located.

    Also, every time you open the Target WB, you'll get a request to "Update
    Links",
    where you have the option to check the Source WB for new data, or to
    continue with the data at hand, from the "last" update.
    --
    HTH,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
    news:ejU3rWfaFHA.3728@TK2MSFTNGP10.phx.gbl...
    > Let XL do the work for you.
    >
    > Open both WBs.
    >
    > Start your formula:
    > =IF(
    > Then navigate to the other WB, and click in the cell that you wish to
    > lookup.
    >
    > XL will add the path to your formula.
    > Then, in the formula bar, add
    > >0,

    > OR
    > <>"",
    >
    > Then click in the cell *again* to repeat the path for the "True"

    condition.
    > End off by adding the "False" condition to the formula bar
    > ,"")
    > OR
    > ,"No Data")
    >
    > Then hit <Enter>.
    >
    > Your formula might look something like this:
    >
    > =IF(Sheet3!A1<>"",Sheet3!A1,"No Data")
    > --
    > HTH,
    >
    > RD
    >
    > --------------------------------------------------------------------------

    -
    > Please keep all correspondence within the NewsGroup, so all may benefit !
    > --------------------------------------------------------------------------

    -
    >
    > "rayteach" <rayteach@discussions.microsoft.com> wrote in message
    > news:309B3F75-5D20-426E-9815-6ADCBA6B091B@microsoft.com...
    > > I want to make an IF function that refers to a cell in another worksheet

    > and
    > > returns the value in that cell. All but the TRUE condition would be
    > > =if(cell>0,,""} … In other words, if the referenced cell has data in it,

    I
    > > want whatever data is there to be the result of the formula. How do I do

    > this?
    > > --
    > > ray

    >



  4. #4
    rayteach
    Guest

    Re: If function that returns value in a cell.

    Thank you so much, Ragdyer - your formula worked perfectly.
    --
    ray


    "Ragdyer" wrote:

    > Let XL do the work for you.
    >
    > Open both WBs.
    >
    > Start your formula:
    > =IF(
    > Then navigate to the other WB, and click in the cell that you wish to
    > lookup.
    >
    > XL will add the path to your formula.
    > Then, in the formula bar, add
    > >0,

    > OR
    > <>"",
    >
    > Then click in the cell *again* to repeat the path for the "True" condition.
    > End off by adding the "False" condition to the formula bar
    > ,"")
    > OR
    > ,"No Data")
    >
    > Then hit <Enter>.
    >
    > Your formula might look something like this:
    >
    > =IF(Sheet3!A1<>"",Sheet3!A1,"No Data")
    > --
    > HTH,
    >
    > RD
    >
    > ---------------------------------------------------------------------------
    > Please keep all correspondence within the NewsGroup, so all may benefit !
    > ---------------------------------------------------------------------------
    >
    > "rayteach" <rayteach@discussions.microsoft.com> wrote in message
    > news:309B3F75-5D20-426E-9815-6ADCBA6B091B@microsoft.com...
    > > I want to make an IF function that refers to a cell in another worksheet

    > and
    > > returns the value in that cell. All but the TRUE condition would be
    > > =if(cell>0,,""} … In other words, if the referenced cell has data in it, I
    > > want whatever data is there to be the result of the formula. How do I do

    > this?
    > > --
    > > ray

    >
    >


  5. #5
    Ragdyer
    Guest

    Re: If function that returns value in a cell.

    Thanks for the feed-back.
    --
    Regards,

    RD

    ---------------------------------------------------------------------------
    Please keep all correspondence within the NewsGroup, so all may benefit !
    ---------------------------------------------------------------------------
    "rayteach" <rayteach@discussions.microsoft.com> wrote in message
    news:03F7CA8E-B3EB-4693-AA2A-666AAFC88377@microsoft.com...
    > Thank you so much, Ragdyer - your formula worked perfectly.
    > --
    > ray
    >
    >
    > "Ragdyer" wrote:
    >
    > > Let XL do the work for you.
    > >
    > > Open both WBs.
    > >
    > > Start your formula:
    > > =IF(
    > > Then navigate to the other WB, and click in the cell that you wish to
    > > lookup.
    > >
    > > XL will add the path to your formula.
    > > Then, in the formula bar, add
    > > >0,

    > > OR
    > > <>"",
    > >
    > > Then click in the cell *again* to repeat the path for the "True"

    condition.
    > > End off by adding the "False" condition to the formula bar
    > > ,"")
    > > OR
    > > ,"No Data")
    > >
    > > Then hit <Enter>.
    > >
    > > Your formula might look something like this:
    > >
    > > =IF(Sheet3!A1<>"",Sheet3!A1,"No Data")
    > > --
    > > HTH,
    > >
    > > RD
    > >

    >
    > --------------------------------------------------------------------------

    -
    > > Please keep all correspondence within the NewsGroup, so all may benefit

    !
    >
    > --------------------------------------------------------------------------

    -
    > >
    > > "rayteach" <rayteach@discussions.microsoft.com> wrote in message
    > > news:309B3F75-5D20-426E-9815-6ADCBA6B091B@microsoft.com...
    > > > I want to make an IF function that refers to a cell in another

    worksheet
    > > and
    > > > returns the value in that cell. All but the TRUE condition would be
    > > > =if(cell>0,,""} … In other words, if the referenced cell has data in

    it, I
    > > > want whatever data is there to be the result of the formula. How do I

    do
    > > this?
    > > > --
    > > > ray

    > >
    > >



+ 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