Forum Discussion
Help with Nested IF AND Statement
Hello, My team and I have been working on logic for a report, but we cannot get it to work accurately across all criteria that we need it for. Here's the logic that we need to include: 1. If Colum...
=IF(AP2="CPU", IF(AE2="", IF(AD2<TODAY(), "RED", IF(AD2<TODAY()+3, "YELLOW", "RED")), IF(AE2<=AD2, "GREEN", "RED")), IF(AE2="", IF(AN2<TODAY(), "RED", IF(AN2<TODAY()+3, "YELLOW", "RED")), IF(AE2<=AD2, "GREEN", "RED")))
Or
=IF(AE2="", IF(IF(AP2="CPU", AD2, AN2)<TODAY(), "RED", IF(IF(AP2="CPU", AD2, AN2)<TODAY()+3, "YELLOW", "RED")), IF(AE2<=AD2, "GREEN", "RED"))
That worked! Thank you so much!!