•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#AND
#conditional formatting
#overdue
#Order placed
#TODAY
#display text
#IF
#DUE TODAY
#Excel
#formula
#function
#Excel formulas
#overdue items
#item status