ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #REF (https://www.excelbanter.com/excel-discussion-misc-queries/83240-ref.html)

Monty

#REF

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

Any help Please

papou

#REF

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

HTH
Cordially
Pascal
"Monty" a écrit dans le message de news:
...
How can i change the cell from this (#REF) to this (0.00) or can i just
hide
this ref.

Any help Please

Niek Otten

#REF

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

--
Kind regards,

Niek Otten

"Monty" 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

Niek Otten

#REF

Typo:

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

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message ...
| =IS(ISERROR(A1),0,A1)
|
| --
| Kind regards,
|
| Niek Otten
|
| "Monty" 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
|
|

All times are GMT +1. The time now is 12:40 PM.