The error is on the OR function
Try
=(IF( OR (O500C500;C500C499) ),0,(C500-O500)*30
-----------------------------------------------
~~ Message posted from
http://www.ExcelTip.com
~~View and post usenet messages directly from
http://www.ExcelForum.com