If, Then Statement

[summer]

I have database that tracks calibration due dates. The formula I am using in the report to show whether a device is out of calibration is:
=IIf([Due Date]>Now(),"OK","OUT OF CALIBRATION")
The result of this formula gives the value in my “Status” column.

Here's what I want to do. I need to add a column to my report that shows if a device was lost. The date the device was calibrated and its due date will be deleted because the device is obviously no longer used, but when this is done, it shows the device is OUT OF CALIBRATION in the “Status” column.

Can I add to the above formula to tell it if the “lost” column is checked, not to put “out of calibration”?
Or can I add to the formula if the Due Date is Null, to put in the status column Lost?

I hope this isn’t confusing!

 

[cpod]

=iif([due date] is null,"Lost",IIf([Due Date]>Now(),"OK","OUT OF CALIBRATION"))

 

[summer]

That worked. But I have a problem. I have another column, "out for calibration", which is checked if something is sent out of the building to be calibrated. The due date is deleted from this column. The current formula returns an "out of calibration" result in the "Status" column. With this new formula, since the due date column is null; it is now returning a “lost” result in the “status” column, when it should remain “out of calibration”. Again, I hope this makes sense.
Thanks for your help.