Excel 2007 : Two conditions for a single cell

[srobbins]

Requesting Help!

I have a spreadsheet where I am tracking ontime and late delivery of shipments. I have built a formula to populate "Ontime" and "Late" depending on expected delivery date (Column F) and actual delivery date (Column H). There are shipments on the spreadsheet that have not delivered and therefore do not display values in column H. I would like these shipments to display "n/a" in the conditional format I have established, but I'm not sure how to combine two conditions for a single cell.

Current Formula: =IF(H14<=F14,"Ontime","Late")

Spreadsheet Example Attached

Any assistance is greatly appreciated!!

Thank you

[TMS]

Is this what you're looking for:

Cell K2: =IF(H2="","n/a",IF(H2<=F2,"Ontime","Late"))


Regards, TMS