First of all 0 is returned as text in your formula if you want it as a
number loose the " "


You need to tell us your situations


If a1<0
else if a40

or if a1<0 and a40

Explain it clearly in english and then someone will give you the right
answer

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=562380