Hi Guys
I have 2 columns with Transit Times.
I have created a formula in Column C saying "If(A1>B1,"Delayed","On-Time")
However, some of the the dates in Column A are blank, so I want to say the above but then if any cells are blank in column A then "TBA", so that when I populate in column C it will show TBA instead of an error.
Can you please help.
Thanks
Fentoei
Bookmarks