Try the following:
=IF(A1+B1<=1800,A1+B1,IF(A1+B11800,1800,"Check"))
The "Check" can be any value you want for the false part of the last IF
statement - This can be a warning or you can set it to 1800 also


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=498457