I don't think that will fly, "" can be used as a result (kinda) but not as a
term.

i.e. If this formula "=If(A3=0,"",A3)" was in cell A2 , then a "0" was
entered in cell A3, Cell A2 would be blank (not a "0"). Any other values
would be placed in cell A2 normally.

If you are looking for blank values to do something than look into ISEMPTY
function


"calline6" wrote in message
...
then does it mean, for instance in the b.m. formula,

=if(a3="",a2,a3) whereby a3 is a name and a2 is blank

thanks for the clarification

" wrote:

then nothing will be displayed. It's one way to get rid of "#value" error
messages

"calline6" wrote in message
...
I always come across the usage of a double quotation mark but don't
really
know what does it mean. If the double quotes encloses a word, then the
word
will be display. What if it is just opened and closed quotes?

Thanks