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.

Perhaps something like, in say C1:
=IF(OR(TRIM(B1)="",ISTEXT(B1)),"",B1*5)
may suffice

C1 will appear blank until a real number is input in B1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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.