formula was copied from a worksheet where it was producing the correct
results. I would suggest your formula has a typo.

--
Regards,
Tom Ogilvy


"Teerings3" wrote
in message ...

both of your assumptions are correct, but I get a Name#? error


--
Teerings3
------------------------------------------------------------------------
Teerings3's Profile:
http://www.excelforum.com/member.php...o&userid=29560
View this thread: http://www.excelforum.com/showthread...hreadid=492859