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

=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.

--
__________________________________
HTH

Bob

"MJS" wrote in message
...
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

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


On Feb 12, 6:08*pm, 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

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

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

Brilliant guys€¦All worked perfectly.

Cheers,


"Eduardo" wrote:

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

"MJS" wrote:
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
---