IF Statement - Correct Function?

[MJS]

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

 

[Bob Phillips]

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

is that AND correct? < today AND blank, that is just the same as blank.

 

[muddan madhu]

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

 

[Max]

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

 

[Eduardo]

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

 

[MJS]

Brilliant guys…All worked perfectly.

Cheers,

 

[Max]

Brilliant guys…All worked perfectly.

Except for my guess, which sticks out like a sore thumb <g>

I'd admit I was, like Bob?, a bit hesitant about your term:
AND(R2<TODAY(),R5="")
(though you didn't ask for it to be reviewed in your post)

Thought you might actually want to disregard blanks in R5
(imo, blanks might just mean: data not available, omitted, etc
rather than be construed as deadline not met?)

hence revised it instead to check sequentially as:
.... IF(R5="","",IF(R2<TODAY(),"Overdue","In Progress") ..

Above fwiw ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---