Please make it easier to access the IS functions (e.g., isblank) .

[Guest]

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Paul Sheppard]

I was referencing another cell with an Excel formula and wanted th
formula
to return a blank cell if the referenced cell was blank. I searche
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'
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
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
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 th
"I
Agree" button in the message pane. If you do not see the button, follo
this
link to open the suggestion in the Microsoft Web-based Newsreader an
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 i
the cell is not blank

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

 

[Blue Hornet]

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.

 

[CLR]

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

=A2

Vaya con Dios,
Chuck, CABGx3

 

[RagDyeR]

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

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

=A2

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

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

 

[CLR]

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]

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

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

 

[CLR]

lolol............of course the whole thing boils down to this being
fun.........since the OP did not specify every exact condition possible
(which you know they almost never do) we must guess at what conditions will
satisfy their need........and, in offering all the different options we can
think of, folks who follow the thread can see that sometimes what they think
they want, is not what they actually really want, depending on the
conditions............anyway, I've enjoyed this one and now it's nite nite
time in St. Petersburg Florida where we've just dodged another
hurricane........sure feel sorry for those folks up on the Gulf
Coast........our prayers and good wishes are with you...........

Vaya con dios,
Chuck, CABGx3

 

[Blue Hornet]

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