Multiple IF functions

[Vocieee]

Hi there,

I have this formula "=IF(H9-NOW()<0,"OVERDUE",IF(H9<(NOW()+15),"DUE",IF(H9<(NOW()+90),"PLAN","NOT DUE")))" in I9, however I'm having trouble adding another IF function. I want to add that if J9 has any text in, that changes I9 to "Planned". Is this possible?

Thanks!

[HansDouwe]

What means "if J9 has any text in"? Is that if J9 not empty? Is that if J9 not a numeric value? Is that ???

[Vocieee]

Basically J9 is a "Date Planned" column. However we don't use generic dd/mm/yy. We plan by weeks. So once J9 has any value or text in it. Sorry, didnt explain that too well.

[HansDouwe]

I want to add that if J9 has any text in, that changes I9 to "Planned".

Please try in I9: =IF(J9<>"";"Planned";IF(H9-NOW()<0,"OVERDUE",IF(H9<(NOW()+15),"DUE",IF(H9<(NOW()+90),"PLAN","NOT DUE"))))

[Gregb11]

So you mean if J9 is not blank? Also, is that the last check you want to do? Meaning, if H9-Now()<0 AND J9 is blank, what do you want, "OVERDUE" or "Planned". If the later, you could do:

=IF(H9-NOW()<0,"OVERDUE",IF(H9<(NOW()+15),"DUE",IF(H9<(NOW()+90),"PLAN",IF(J9<>"","Planned","NOT DUE"))))
or, use IFS: (I'm writing this "free-hand" so I may have messed up on structure)
=IFS(H9-NOW(),0,"OVERDUE",H9<(NOW()+15),"DUE",H9<(NOW()+90,"PLAN",J9<>"","Planned",TRUE,"NOT DUE")

Also, if this isn't correct, it's best to add a sample file to your post.

[Vocieee]

Test.xlsx

Sorry not explaining this very well. Regardless of whether its due, not due, overdue or plan. As soon as J9 isn't blank I would like I9 to change to planned.
Thanks.

[Crooza]

I think all you need is this

Please Login or Register  to view this content.

[HansDouwe]

As soon as J9 isn't blank I would like I9 to change to planned.

Answer is already given in Post #4

[Vocieee]

Thanks everyone, all sorted now!