Maybe like this:
=IF(AH21="u","Complete",IF(R5="","",IF(R2<TODAY(), "Overdue","In Progress")))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"MJS" wrote:
I am putting together a task schedule on Excel and struggling to pull
together the formula i require.
Basically i have a formula in place, located in cell B5, to say whether a
task is "overdue" or "In Progress".

=IF((AND(R2<TODAY(),R5="")),"Overdue","In Progress")

However i need an overriding formula, or some way to integrate the below
formula into to original so that when i put a "u" in cell AH21, it changes
cell B5 to "Complete", ignoring "Overdue" and "In progress".

=IF(AH21="u","Complete")