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