Iserror question

S

swedish max

I came across an interesting formula today and was hoping to find out
what it did.

The formula was =if(iserror(all),"0",b22/b23)

The confusing part was ALL. It seemed to work for one cell then error
on the rest as it was copied down. I've never seen this used before -
anyone any ideas what this ALL command is? Obviously, I replaced it
was the corrected terminology so it works no problem now but just
wanted to see if anyone knew.

Cheers

Max
 
C

CLR

"ALL" is evidently a RangeName..............

Select a cell, do Insert > Name > Define > and name it ALL, then see how the
formula performs.........

Vaya con Dios,
Chuck, CABGx3
 
D

Dave Peterson

Or try:
Edit|goto|
and type All in that reference box at the bottom and hit ok.

(You may be able to select All from the list above that reference box, too.)
 
Top