| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#REF
How can i change the cell from this (#REF) to this (0.00) or can i just hide
this ref. Any help Please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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 |
|
#4
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 | |
|
|
Linear Mode
