EXCEL hide #VALUE!
Solved
Annabelle30
Posted messages
6
Status
Membre
-
Tulleb -
Tulleb -
Hello everyone,
I created a table with formulas but since it is not filled yet, there are cells displaying #VALUE! and I would like to get rid of them.
I know it's a topic that has already been addressed, and I've tried several solutions without much success. So, I'm sharing the link below so you can take a look at the file I created.
https://www.cjoint.com/?BFvpvwMWAsb
config>Windows 7 / Internet Explorer 9.0</config>
I created a table with formulas but since it is not filled yet, there are cells displaying #VALUE! and I would like to get rid of them.
I know it's a topic that has already been addressed, and I've tried several solutions without much success. So, I'm sharing the link below so you can take a look at the file I created.
https://www.cjoint.com/?BFvpvwMWAsb
config>Windows 7 / Internet Explorer 9.0</config>
4 réponses
Hello,
The cells returning #value contain formulas.
Let’s assume your cell A1 contains a formula returning #value and that this formula is: =MYFORMULA(Z1)
You can replace this formula in cell A1 with:
=IF(ISERROR(MYFORMULA(Z1),"",MYFORMULA(Z1))
Okay, it’s not a good solution, but hiding errors is very rarely (if ever) a good solution!
--
Best regards,
Franck P
The cells returning #value contain formulas.
Let’s assume your cell A1 contains a formula returning #value and that this formula is: =MYFORMULA(Z1)
You can replace this formula in cell A1 with:
=IF(ISERROR(MYFORMULA(Z1),"",MYFORMULA(Z1))
Okay, it’s not a good solution, but hiding errors is very rarely (if ever) a good solution!
--
Best regards,
Franck P
=IF(ISERROR(MYFORMULA(Z1));"";MYFORMULA(Z1))