SOLVED

New Contributor

# Nested IF with a number of days

I am trying to have cells in one column turn a color with a message when the date is within the below parameters (I just need help with the formula, not the colors). I know I am missing a piece of the formula, but cannot figure out how to nest it.

If the publication date (column G) is:

• Between 0 and 304 days, show In Compliance (I was able to do this)
• Between 305 and 365 days, show Warning! (this is what I can’t figure out)
• More than 365 days, show Review Required (I was able to do this)
• If it is a new document that hasn’t yet been published, show TBD (I was able to do this)
6 Replies

# Re: Nested IF with a number of days

@Rnajar Try it this way:

``=LOOKUP(DAYS360(G6,TODAY()),{0,305,366},{"In Compliance","Warning","Review Required"})``

best response confirmed by Rnajar (New Contributor)
Solution

# Re: Nested IF with a number of days

Try this:
=IF(G6="TBD","TBD",LOOKUP(TODAY()-G6,{0,305,366},{"In Compliance","Warning","Review Required"}))

# Re: Nested IF with a number of days

@JMB17 Minds alike, though I forgot about the "TBD" part of the formula.

# Re: Nested IF with a number of days

I just caught it myself before posting.

# Re: Nested IF with a number of days

IT WORKED!!!! THANK YOU SO MUCH. I have spent hours on this.

# Re: Nested IF with a number of days

You are welcome - that is good to hear.