software

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

Any help Please

Hello
=IF(ISERROR(yourformulahere),0,yourformulahere)

HTH
Cordially
Pascal
quot;Montyquot; gt; a écrit dans le message de news:
...
gt; How can i change the cell from this (#REF) to this (0.00) or can i just
gt; hide
gt; this ref.
gt;
gt; Any help Please
=IS(ISERROR(A1),0,A1)

--
Kind regards,

Niek Otten

quot;Montyquot; gt; wrote in message ...
| How can i change the cell from this (#REF) to this (0.00) or can i just hide
| this ref.
|
| Any help Please
Typo:

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

--
Kind regards,

Niek Ottenquot;Niek Ottenquot; gt; wrote in message ...
| =IS(ISERROR(A1),0,A1)
|
| --
| Kind regards,
|
| Niek Otten
|
| quot;Montyquot; gt; wrote in message ...
|| How can i change the cell from this (#REF) to this (0.00) or can i just hide
|| this ref.
||
|| Any help Please
|
|