I WANT TO HIDE THIS #DIV0!
Hi herman,
use in an if function in your cell eg. =if(iserror(a1/a2),0,(a1;a2))
change a1 a2 per your original formulas
hth
regards from Brazil
Marcelo
"HERNAN" escreveu:
I had a formula in a cell, that when ocurred I want it to hide, it says
#DIV0! and when I try to sort that column it mess everything that message.
I would like for example to say 0 instead of that error message, but I don't
know how to do it.
I would appriciate any help.
Thank you
|