#div/0

[ajm]

hi again. simply can't get my tired brain aroud this one.

I want to hide my #div/0's. such that if the result of the formula in a particular cell is going to return an error, give me "" instead or even "-".

I've done this before with something of a If(n(.... but I can't recall what it was.

 

[JohnnyTightlips]

you are thinking of iserror

e.g. =if(iserror(yourformula),"",yourformula)

 

[Aladin Akyurek]

hi again. simply can't get my tired brain aroud this one.

I want to hide my #div/0's. such that if the result of the formula in a particular cell is going to return an error, give me "" instead or even "-".

I've done this before with something of a If(n(.... but I can't recall what it was.

Depends on the formula you want to setup... Generically:

=IF(N(Y2),X2/Y2,"")

If Y2 might house an error value...

=IF(ISNUMBER(Y2),IF(N(Y2),X2/Y2,""),"")

 

[ajm]

thanks guys. formulas work perfectly. perhaps i should have tried originally to put them into the right place with the right references. long story and its now time to go home.

lets hope my little fella sleeps tonight so you guys won't get me asking silly questions again tomorrow.