Create "IF" formula to generate different results based on values in multiple rows

**abhinavn** · 09-29-2010, 01:26 PM

Hello friends,
I need to write a formula to process the following can you please help
if column k (where k = status) is not populated, and column h (where h = date) is > than todays date,
then column j = Behind Schedule if column h is not populated, then column j = Not reported

Can you please help me convert this into a formula. Can I used "If" formula for this. I tried a couple of times but it did not work

Please help.
Thank you

**Vinodsralian** · 09-29-2010, 02:07 PM

Try this in J1 =IF(AND(K1<>"", H1 > TODAY()),"Behind Schedule",IF(H1="","Not Reported",""))
If my understanding is wrong, kindly upload sample spreadsheet

**abhinavn** · 09-29-2010, 03:28 PM

Thank you Vinod,

So I modified the formula a little bit to get desired results, this is what I currently have
=IF(AND(K8="",H8>TODAY()),"On Target",IF(H8="","Not Reported",K8))

I wanted to add another factor to the first part
So currently if the date in H8 is > Today it says On Target but if the date is <today I want it to say behind schedule. Can you please help me add that part.

Thank you