| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#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 | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
