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" wrote in message
...
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.
|