Multiple Statements in Formula

[Dummy Excel]

Hi All,
the below is my formula and it works

=If(and(O84="Unavailable (Tagged Out)",E84=""),"Unavailable",If(and(O84="Unavailable (Tagged Out)",E84="Completed (Repairs completed, <b>Available</b> and safe to use)"),"Available", If(and(O84="Unavailable (Tagged Out)",E84="In-Progress (<b>Unavailable</b>, tagged out and not safe to use)"),"Unavailable", If(and(O84="Available (Not Tagged Out)" ,E84="Completed (Repairs completed, <b>Available</b> and safe to use)"),"Available", If(and(O84="Available (Not Tagged Out)" ,E84="In-Progress (<b>Unavailable</b>, tagged out and not safe to use)"),"Unavailable", If(and(O84="Available (Not Tagged Out)",E84=""),"Available" , "Available"))))))

Although now i need to add another "AND" statement (i think?) in and i cant get it to work. The addition is i need to check the date as well which is in column "G". Basically if the date = today then make it "Unavailable", otherwise continue on with the formula. Is this possible?

thanks for your help
Sam

 

[Dummy Excel]

Hi Eric,
I can say it works perfectly.
I actually copied your formula row by row to confirm what you formula does matches mine. It didn't on a few of the rows, although your formula was correct and not mine.
I think you are correct to shorten the formula to make it easier to follow.

Thank you for your time and patience, I really appreciate it

thanks
Sam

 

[Eric W]

Sometimes it just takes looking at a problem from another angle. Once you created the table, it was easy enough to find the patterns which made it easy to make a shorter, easier to understand formula.

Glad I could help.