That IS leaving the cell blank, though not empty because there is a formula
in it.

wrote in message
ups.com...
very often I need write a formula like "=if(a10, 1, "")", but the
second value "" really should just be leave the cell blank (doing
nothing). is there anyway of doing that in stead of "".