Hi,
=IF(AH21="u","Complete",IF((AND(R2<TODAY(),R5="")) ,"Overdue","In Progress"))

"MJS" wrote:

Hey,
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")

Thanks,

Mike