Jermsalerms:

Usually the #NAME! error means you are trying to use a function in the
Analysis ToolPak without the add-in loaded. But since the formula I
posted doesn't include any of those functions, you probably have a typo
in your formula.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=516297