I was referencing another cell with an Excel formula and wanted the formula
to return a blank cell if the referenced cell was blank. I searched for
"blank" and "if" in Excel help and didn't find the function to do this. My
formula ended up being:
=IF($A3=$A2,IF(ISBLANK(D3)=TRUE,"",D3),"")
I found help with this at
http://www.mrexcel.com/archive/Formatting/22701.html .
Please make it easier to find this info in Excel's help menu. I'm using
Excel 2003 Standard Edition. Thanks!

The following is what is found at web address listed above:

cell 1 has nothing in it.
cell 2 references cell 1.
cell 2 displays "0"
I want cell 2 to have nothing in it as well.

=if(isblank(a2)=true,"",a2)
Posted by Eric on July 10, 2001 11:43 AM

Assuming the data you want to report is in a2.
Hope that helps : Does anyone know how to stop a cell from displaying 0 when
I set it equal to the value of another cell (using the formula: =sheet1!a1)
and there is nothing in that cell? cell 2 references cell 1. cell 2 displays
"0" I want cell 2 to have nothing in it as well. thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

melyndac2005 Wrote:
I was referencing another cell with an Excel formula and wanted the
formula
to return a blank cell if the referenced cell was blank. I searched
for
"blank" and "if" in Excel help and didn't find the function to do this.
My
formula ended up being:
=IF($A3=$A2,IF(ISBLANK(D3)=TRUE,"",D3),"")
I found help with this at
http://www.mrexcel.com/archive/Formatting/22701.html .
Please make it easier to find this info in Excel's help menu. I'm
using
Excel 2003 Standard Edition. Thanks!

The following is what is found at web address listed above:

cell 1 has nothing in it.
cell 2 references cell 1.
cell 2 displays "0"
I want cell 2 to have nothing in it as well.

=if(isblank(a2)=true,"",a2)
Posted by Eric on July 10, 2001 11:43 AM

Assuming the data you want to report is in a2.
Hope that helps : Does anyone know how to stop a cell from displaying 0
when
I set it equal to the value of another cell (using the formula:
=sheet1!a1)
and there is nothing in that cell? cell 2 references cell 1. cell 2
displays
"0" I want cell 2 to have nothing in it as well. thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://tinyurl.com/9jpe7

Hi melyndac2005

The following will return a blank if the cell is blank or a value if
the cell is not blank

If(sheet1!A!="","",Sheet1!A!)


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399582

If you work with the "IS" functions a bit more they become much simpler
to use. For example, your formula could be shortened to:

= if ( ISBLANK( A2), "", A2)

you don't need the "= true" portion; it's superfluous. This makes the
formula pretty much English-readable, too.

Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" wrote in message
ups.com...
If you work with the "IS" functions a bit more they become much simpler
to use. For example, your formula could be shortened to:

= if ( ISBLANK( A2), "", A2)

you don't need the "= true" portion; it's superfluous. This makes the
formula pretty much English-readable, too.

Not really!

=A2

Returns a zero, and that's what everyone is trying to avoid ... the zero
display.<g

I can't think of anything shorter (16 characters) then this:

=IF(A2="","",A2)
--

Regards,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"CLR" wrote in message
...
Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" wrote in message
ups.com...
If you work with the "IS" functions a bit more they become much simpler
to use. For example, your formula could be shortened to:

= if ( ISBLANK( A2), "", A2)

you don't need the "= true" portion; it's superfluous. This makes the
formula pretty much English-readable, too.

It depends on whether A2's "blankness" is the result of a formula giving a
null............"then" it shows blank

3 characters, (with condition)
Vaya con Dios,
Chuck, CABGx3



"RagDyeR" wrote in message
...
Not really!

=A2

Returns a zero, and that's what everyone is trying to avoid ... the zero
display.<g

I can't think of anything shorter (16 characters) then this:

=IF(A2="","",A2)
--

Regards,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"CLR" wrote in message
...
Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" wrote in message
ups.com...
If you work with the "IS" functions a bit more they become much simpler
to use. For example, your formula could be shortened to:

= if ( ISBLANK( A2), "", A2)

you don't need the "= true" portion; it's superfluous. This makes the
formula pretty much English-readable, too.

Well, if we only have to deal with "empty cell" (no formula) or a number in
A2, then

=IF(A2,A2,"") ........(13 characters) <gg

Vaya con Dios,
Chuck, CABGx3



"RagDyeR" wrote in message
...
Not really!

=A2

Returns a zero, and that's what everyone is trying to avoid ... the zero
display.<g

I can't think of anything shorter (16 characters) then this:

=IF(A2="","",A2)
--

Regards,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"CLR" wrote in message
...
Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" wrote in message
ups.com...
If you work with the "IS" functions a bit more they become much simpler
to use. For example, your formula could be shortened to:

= if ( ISBLANK( A2), "", A2)

you don't need the "= true" portion; it's superfluous. This makes the
formula pretty much English-readable, too.

You're cheating *again*!<g

You're telling me I can"t use text, so that doesn't count.
--

Regards,

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

"CLR" wrote in message
...
Well, if we only have to deal with "empty cell" (no formula) or a number in
A2, then

=IF(A2,A2,"") ........(13 characters) <gg

Vaya con Dios,
Chuck, CABGx3



"RagDyeR" wrote in message
...
Not really!

=A2

Returns a zero, and that's what everyone is trying to avoid ... the zero
display.<g

I can't think of anything shorter (16 characters) then this:

=IF(A2="","",A2)
--

Regards,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"CLR" wrote in message
...
Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" wrote in message
ups.com...
If you work with the "IS" functions a bit more they become much simpler
to use. For example, your formula could be shortened to:

= if ( ISBLANK( A2), "", A2)

you don't need the "= true" portion; it's superfluous. This makes the
formula pretty much English-readable, too.

Doesn't work when A2 is a text value. I'm sticking with ISBLANK.