Calculating a status based on date and a Y/N Value in a seperate cell

[Mchgh9]

Hi, </SPAN>

I am trying to work out the status of something based on a date, while first checking a column to see if something is complete.</SPAN>

=IF(L6>$L$4,"Pending","Expired") – This is in cell M6</SPAN>

L6 contains todays date</SPAN>
L4 contains the date a piece of work was due to be completed.</SPAN>
I need the formula to be </SPAN>

In column Q I have a cell which contains a state of either Y or N, which relates to the work being completed.</SPAN>

If column Q contains a Y I want the result to be “completed”, otherwise display pending or expired based upon the date values.</SPAN>

So in Pseudo if column Q is Yes, then “Completed” ELSE =IF(L6>$L$4,"Pending","Expired")</SPAN>

I’m just a little stuck on how to write this, any help much appreciated.</SPAN>

Thanks</SPAN>

David</SPAN>
Hi, </SPAN>

I am trying to work out the status of something based on a date, while first checking a column to see if something is complete.</SPAN>

=IF(L6>$L$4,"Pending","Expired") – This is in cell M6</SPAN>

L6 contains todays date</SPAN>
L4 contains the date a piece of work was due to be completed.</SPAN>
I need the formula to be </SPAN>

In column Q I have a cell which contains a state of either Y or N, which relates to the work being completed.</SPAN>

If column Q contains a Y I want the result to be “completed”, otherwise display pending or expired based upon the date values.</SPAN>

So in Pseudo if column Q is Yes, then “Completed” ELSE =IF(L6>$L$4,"Pending","Expired")</SPAN>

I’m just a little stuck on how to write this, any help much appreciated.</SPAN>

Thanks</SPAN>

David</SPAN>

 

[bbott]

Try:

=IF(Q6="Y","Completed", IF(L6>$L$4,"Pending","Expired"))</SPAN>

 

[Mchgh9]

Hi,

That's perfect.

Thanks

Dave

 

[bbott]

You're welcome.