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.