=IF(A140,(A1-40)*12.5*1.5+40*12.5,A1*12.5)
This should work


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=536225