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


--
swedish max
------------------------------------------------------------------------
swedish max's Profile: http://www.excelforum.com/member.php...o&userid=24408
View this thread: http://www.excelforum.com/showthread...hreadid=514412

"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



"swedish max" wrote:


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


--
swedish max
------------------------------------------------------------------------
swedish max's Profile: http://www.excelforum.com/member.php...o&userid=24408
View this thread: http://www.excelforum.com/showthread...hreadid=514412

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.)

swedish max wrote:

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

--
swedish max
------------------------------------------------------------------------
swedish max's Profile: http://www.excelforum.com/member.php...o&userid=24408
View this thread: http://www.excelforum.com/showthread...hreadid=514412

--

Dave Peterson