View Single Post
  #4   Report Post  
CLR
 
Posts: n/a
Default

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.