Presume the problem is EN3 being zero so....

Try wrapping it in an IF statement so that if(EN3=0,0,Your formula)

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=529992