#REF

M

Monty

How can i change the cell from this (#REF) to this (0.00) or can i just hide
this ref.

Any help Please
 
N

Niek Otten

=IS(ISERROR(A1),0,A1)

--
Kind regards,

Niek Otten

| How can i change the cell from this (#REF) to this (0.00) or can i just hide
| this ref.
|
| Any help Please
 
N

Niek Otten

Typo:

=IF(ISERROR(A1),0,A1)

--
Kind regards,

Niek Otten


| =IS(ISERROR(A1),0,A1)
|
| --
| Kind regards,
|
| Niek Otten
|
|| How can i change the cell from this (#REF) to this (0.00) or can i just hide
|| this ref.
||
|| Any help Please
|
|
 
Top