•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Display text if AND is true
I am using an and statement =AND(N16="Order placed",TODAY()>J16) for conditional formating to tell me when items are overdue. I'd like to display text if true "OVERDUE" "DUE TODAY" etc.
I tried =(IF(AND(N16="Order placed",TODAY()=J16),"OVERDUE" and that doesn't appear to work.
[link] [comments]
Want to read more?
Check out the full article on the original site