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
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
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
>
>
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
>>
>>
>
>
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
>>>
>>>
>>
>>
>
>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks