How to represent an empty cell in excel formulae?
 

The formula should work only when the cell has some value and should not take
the emptyness as zero value. Is there a way where by an empty cell can be
represented or is there any other way to activate the formula only when cell
has some value.

How to represent an empty cell in excel formulae?
 

A number of ways

=ISBLANK(A1)
=A1=""

both these will be false if A1 has a formula in it.

=LEN(A1)=0

this will return true if there is a formula returning ""

--
HTH

Bob Phillips

"Sibi Melvin" <Sibi wrote in message
...
The formula should work only when the cell has some value and should not
take
the emptyness as zero value. Is there a way where by an empty cell can be
represented or is there any other way to activate the formula only when
cell
has some value.