0 entry vs blank cell
 

Is there a way to have Excel know the differance between a 0 entry and a
blank cell?
I am trying to mask a blank cell (input data cell) that is referenced in a
formula (output cell) so that it returns a blank, but if a 0 is entered into
the input cell I want the 0 to be shown in output cell.

0 entry vs blank cell
 

Something like

IF(ISBLANK(A1),"",A1)

"Motion" wrote:

Is there a way to have Excel know the differance between a 0 entry and a
blank cell?
I am trying to mask a blank cell (input data cell) that is referenced in a
formula (output cell) so that it returns a blank, but if a 0 is entered into
the input cell I want the 0 to be shown in output cell.

0 entry vs blank cell
 

Hi Motion,

IsBlank(yourcell) will produce True if the cell is blank, and will
produce False if the cell is 0 ...

HTH
Cheers
Carim

0 entry vs blank cell
 

=if(a1="","",a1)

Motion wrote:

Is there a way to have Excel know the differance between a 0 entry and a
blank cell?
I am trying to mask a blank cell (input data cell) that is referenced in a
formula (output cell) so that it returns a blank, but if a 0 is entered into
the input cell I want the 0 to be shown in output cell.

--

Dave Peterson