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.