Menu
I want to hide all #DIV/0! errors and #N/A errors for data that hasn't been inputted. (So just have an empty cell.) The current data I have:
661
transitive verb. 1a : to put out of sight : secrete hide a key under the doormat. b : to conceal for shelter or protection : shield They hid him from the police. 2 : to keep secret hide the truth. 3 : to screen from or as if from view : obscure clouds hid the sun.
Some common synonyms of hide are bury, conceal, screen, and secrete. While all these words mean "to withhold or withdraw from sight," hide may or may not suggest intent.
Definition of hideout : a place of refuge, retreat, or concealment a criminal's secret hideout.
To scold or punish someone harshly. The boss will have my hide if he finds out that I was the one responsible for the printing error.
Rather than using the IF formula, I suggest using the IFERROR formula. That way you won't need to worry about possible error conditions.
Case of #VALUE! error:
=IFERROR("a" + 1,"")
Case of #DIV/0! error:
=IFERROR(3/0,"")
The second parameter is optional, so you can even simplify the formulas to:
=IFERROR("a" + 1)
=IFERROR(3/0)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
