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