Hi guys, need a bit of help here.
I've got a formula that I'm working on for a spreadsheet.
The sheet shows a list of dates etc.
The formula I have set up currently is:
=IF(TODAY()>=L2-3,"DUE","CURRENT")
thats what i got so far, so basically, if the "deadline" is within 3 days the warning will change to "DUE"
However, is it possible to have this "overidden" if the work has been completed, which would be populated in column O by a date.
i.e. Completion Date (Column O) = 01/06/11. This would need to be applied to several hundred rows.
So is there a way to do that, like IF column O has a date then "COMPLETE" not "DUE"?
Thanks guys.
Bookmarks