Great thanks for the help!!

Almost there, while this formula displays the number i need which is
good, it displays 0 when all three cells are #N/A, and in this
situation need it to display #N/A or anything but a number!!!

Andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=501901