+ Reply to Thread
Results 1 to 5 of 5

referencing cells that return blank results

  1. #1
    Suz
    Guest

    referencing cells that return blank results

    Hi gang:

    I need a formula to return results ONLY if the results of the formula in an
    adjacent cell are not blank.

    I hope this is enough information for someone to help.

    Much appreciated if so!

    Sue



  2. #2
    Otto Moehrbach
    Guest

    Re: referencing cells that return blank results

    Say that you want results in B1 only if A1 is not blank. In B1 put your
    formula lake this:
    =If(A1="","",your formula)
    HTh Otto
    "Suz" <Suz@discussions.microsoft.com> wrote in message
    news:2FEA7C50-923A-4D48-AC6E-18A29AF66175@microsoft.com...
    > Hi gang:
    >
    > I need a formula to return results ONLY if the results of the formula in
    > an
    > adjacent cell are not blank.
    >
    > I hope this is enough information for someone to help.
    >
    > Much appreciated if so!
    >
    > Sue
    >
    >




  3. #3
    lee.christopher
    Guest

    Re: referencing cells that return blank results

    This is the standard answer to the question, but the text string "" is
    apparantly not quite the same thing as the property 'Empty' or 'Blank',
    though I don't know exactly what the difference is.

    If your formula writes "" to a cell, the cell is not absolutely blank. As
    far as I'm aware there's no formula that can make a cell blank.

    It's an issue for those who know the older mainframe systems such as RS/1,
    because with Excel, you can't predict exactly how your formula will behave.
    Since the question has been raised about several successive versions of
    Excel, there must be some fundamental limitation with this software. With
    VBA 'UsedRange' poses similar questions.

    Regards


    "Otto Moehrbach" <ottokmnop@comcast.net> a écrit dans le message de news:
    uu7lO5gFFHA.1924@TK2MSFTNGP14.phx.gbl...
    > Say that you want results in B1 only if A1 is not blank. In B1 put your
    > formula lake this:
    > =If(A1="","",your formula)
    > HTh Otto
    > "Suz" <Suz@discussions.microsoft.com> wrote in message
    > news:2FEA7C50-923A-4D48-AC6E-18A29AF66175@microsoft.com...
    >> Hi gang:
    >>
    >> I need a formula to return results ONLY if the results of the formula in
    >> an
    >> adjacent cell are not blank.
    >>
    >> I hope this is enough information for someone to help.
    >>
    >> Much appreciated if so!
    >>
    >> Sue
    >>
    >>

    >
    >




  4. #4
    Otto Moehrbach
    Guest

    Re: referencing cells that return blank results

    Lee
    Of course the cell is not empty. It has a formula in it. The formula
    is written to return a blank cell in that case, not an empty cell. Otto
    "lee.christopher" <lee.christopher@wanadoo.fr> wrote in message
    news:42188f14$0$17270$8fcfb975@news.wanadoo.fr...
    > This is the standard answer to the question, but the text string "" is
    > apparantly not quite the same thing as the property 'Empty' or 'Blank',
    > though I don't know exactly what the difference is.
    >
    > If your formula writes "" to a cell, the cell is not absolutely blank. As
    > far as I'm aware there's no formula that can make a cell blank.
    >
    > It's an issue for those who know the older mainframe systems such as RS/1,
    > because with Excel, you can't predict exactly how your formula will
    > behave. Since the question has been raised about several successive
    > versions of Excel, there must be some fundamental limitation with this
    > software. With VBA 'UsedRange' poses similar questions.
    >
    > Regards
    >
    >
    > "Otto Moehrbach" <ottokmnop@comcast.net> a écrit dans le message de news:
    > uu7lO5gFFHA.1924@TK2MSFTNGP14.phx.gbl...
    >> Say that you want results in B1 only if A1 is not blank. In B1 put your
    >> formula lake this:
    >> =If(A1="","",your formula)
    >> HTh Otto
    >> "Suz" <Suz@discussions.microsoft.com> wrote in message
    >> news:2FEA7C50-923A-4D48-AC6E-18A29AF66175@microsoft.com...
    >>> Hi gang:
    >>>
    >>> I need a formula to return results ONLY if the results of the formula in
    >>> an
    >>> adjacent cell are not blank.
    >>>
    >>> I hope this is enough information for someone to help.
    >>>
    >>> Much appreciated if so!
    >>>
    >>> Sue
    >>>
    >>>

    >>
    >>

    >
    >




  5. #5
    Suz
    Guest

    Re: referencing cells that return blank results

    Thank you both. Otto, after a bit of 'tweaking' the formula worked great!
    Lee, thank you for responding, even though I caused some confusion with the
    way I worded my question.

    Cheers Sue

    ---------------------

    "Otto Moehrbach" wrote:

    > Lee
    > Of course the cell is not empty. It has a formula in it. The formula
    > is written to return a blank cell in that case, not an empty cell. Otto


    > "lee.christopher" <lee.christopher@wanadoo.fr>
    > > This is the standard answer to the question, but the text string "" is
    > > apparantly not quite the same thing as the property 'Empty' or 'Blank',
    > > though I don't know exactly what the difference is.
    > >
    > > If your formula writes "" to a cell, the cell is not absolutely blank. As
    > > far as I'm aware there's no formula that can make a cell blank.
    > >
    > > It's an issue for those who know the older mainframe systems such as RS/1,
    > > because with Excel, you can't predict exactly how your formula will
    > > behave. Since the question has been raised about several successive
    > > versions of Excel, there must be some fundamental limitation with this
    > > software. With VBA 'UsedRange' poses similar questions.
    > >
    > > Regards
    > >
    > > "Otto Moehrbach" <ottokmnop@comcast.net>
    > >> Say that you want results in B1 only if A1 is not blank. In B1 put your
    > >> formula lake this:
    > >> =If(A1="","",your formula)
    > >> HTh Otto


    > >> "Suz" <Suz@discussions.microsoft.com>


    > >>> Hi gang:
    > >>>
    > >>> I need a formula to return results ONLY if the results of the formula in
    > >>> an adjacent cell are not blank.
    > >>>
    > >>> I hope this is enough information for someone to help.
    > >>>
    > >>> Much appreciated if so!
    > >>>
    > >>> Sue



+ 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