using my formula it would be this

=IF(b1="n",a1+2,if(B1<=A1+2,B1,6))

Matt


--
mattjenkins
------------------------------------------------------------------------
mattjenkins's Profile: http://www.excelforum.com/member.php...o&userid=36049
View this thread: http://www.excelforum.com/showthread...hreadid=558421