DOn't worry too much about the name, Ken. I can't get the =ifformula
(which sounds the simplest) to work.

I've tried referring it to the cell it's in without any joy, and I've
tried referring it to A1 and that didn't work ether. What am I doing
wrong?

Thanks


--
Brisbane Rob
------------------------------------------------------------------------
Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096
View this thread: http://www.excelforum.com/showthread...hreadid=517687