View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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