Hide #VALUE! - Is it possible?

[CasperA]

Is it possible in hide the display of the characters #VALUE! in those cells that do not yet display the result of a formula?

CA

 

[gaz_chops]

Try

=iferror(your formula,"")

 

[CasperA]

Try

=iferror(your formula,"")

Thank you, should I put this line in a VBA-editor module? I would like to hide all occurrences of the characters #VALUE! in all columns the spreadsheet.

 

[deletedalien]

The =iferror(your formula,"")

Is an actual Formula, it first check for errors in the result of your formula and if your all good then it will return the formula otherwise it will return "" <--- (blank text)

 

[CasperA]

The =iferror(your formula,"")

Is an actual Formula, it first check for errors in the result of your formula and if your all good then it will return the formula otherwise it will return "" <--- (blank text)

Thank you again, so if I understand it correctly I should replace the words 'your formula' with the formula that I use in the column that I wish to to be processed and use this new formula instead of the old one in the cells of that column?

CA

 

[gaz_chops]

Correct.

 

[CasperA]

Thanks, really appreciated!

CA

 

[gaz_chops]

You're welcome.

 

[CasperA]

Try

=iferror(your formula,"")

If the formula in B1 is =(A1) and I replace it by =iferror(=(A1),"") I receive an error message. What am I doing wrong here? I replaced 'ýour formula' by =(A1), which is my formula.

?

CasperA

 

[CasperA]

The =iferror(your formula,"")

Is an actual Formula, it first check for errors in the result of your formula and if your all good then it will return the formula otherwise it will return "" <--- (blank text)

If the formula in B1 is =(A1) and I replace it by =iferror(=(A1),"") I receive an error message. What am I doing wrong here? I replaced 'ýour formula' by =(A1), which is my formula.

?

CasperA