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

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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.

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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
> >
>
>
>

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.

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





"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:espMop2qFHA.3720@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
> 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" <ragdyer@cutoutmsn.com> wrote in message
> news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> > 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" <croberts@tampabay.rr.com> wrote in message
> > news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> > Just for the record.............the following would be shorter yet.....
> >
> > =A2
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> > news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <croberts@tampabay.rr.com> wrote in message
news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <croberts@tampabay.rr.com> wrote in message
news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
>

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

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <croberts@tampabay.rr.com> wrote in message
news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <croberts@tampabay.rr.com> wrote in message
news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
> >
>
>
>

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

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
>

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





"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:espMop2qFHA.3720@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
> 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" <ragdyer@cutoutmsn.com> wrote in message
> news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> > 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" <croberts@tampabay.rr.com> wrote in message
> > news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> > Just for the record.............the following would be shorter yet.....
> >
> > =A2
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> > news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
> > >
> >
> >
> >
>
>
>

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.

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" <croberts@tampabay.rr.com> wrote in message
news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
> >
>
>
>

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





"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:espMop2qFHA.3720@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
> 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" <ragdyer@cutoutmsn.com> wrote in message
> news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> > 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" <croberts@tampabay.rr.com> wrote in message
> > news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> > Just for the record.............the following would be shorter yet.....
> >
> > =A2
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> > news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.

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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <croberts@tampabay.rr.com> wrote in message
news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
>

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" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <croberts@tampabay.rr.com> wrote in message
news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.

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" <croberts@tampabay.rr.com> wrote in message
news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
> >
>
>
>

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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
> >
>
>
>

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

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
>

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





"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:espMop2qFHA.3720@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
> 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" <ragdyer@cutoutmsn.com> wrote in message
> news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> > 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" <croberts@tampabay.rr.com> wrote in message
> > news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> > Just for the record.............the following would be shorter yet.....
> >
> > =A2
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> > news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
> > >
> >
> >
> >
>
>
>

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

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
>

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...heet.functions

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

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





"RagDyeR" <ragdyer@cutoutmsn.com> wrote in message
news:espMop2qFHA.3720@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
> 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" <ragdyer@cutoutmsn.com> wrote in message
> news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> > 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" <croberts@tampabay.rr.com> wrote in message
> > news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> > Just for the record.............the following would be shorter yet.....
> >
> > =A2
> >
> > Vaya con Dios,
> > Chuck, CABGx3
> >
> >
> > "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> > news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
> > >
> >
> >
> >
>
>
>

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" <croberts@tampabay.rr.com> wrote in message
news:Oqk3%23y1qFHA.332@tk2msftngp13.phx.gbl...
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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <croberts@tampabay.rr.com> wrote in message
news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
Just for the record.............the following would be shorter yet.....

=A2

Vaya con Dios,
Chuck, CABGx3


"Blue Hornet" <wrhs_71@yahoo.com> wrote in message
news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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" <ragdyer@cutoutmsn.com> wrote in message
news:O#obo6zqFHA.3352@TK2MSFTNGP14.phx.gbl...
> 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" <croberts@tampabay.rr.com> wrote in message
> news:%2366a%23kzqFHA.4044@TK2MSFTNGP09.phx.gbl...
> Just for the record.............the following would be shorter yet.....
>
> =A2
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Blue Hornet" <wrhs_71@yahoo.com> wrote in message
> news:1125167508.879887.89360@z14g2000cwz.googlegroups.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.
> >
>
>
>