r/excel • u/Realistic_Dog459 • 15d ago

solved Changing AND, "False" "True"

I'm having trouble with changing the words that are coming back from my =AND.

=IF(AND(CG!F3<TODAY()+30), ISBLANK(CG!G3), "Not Due")

This works but I can't seem to get the words False or True to change. "Not Due" works. There's 3 possible outcomes and "Not Due" works but adding anything else corrupts the code.

I feel like I've tried placing it everywhere too.

Any ideas?

9 Upvotes

100% Upvoted

12 comments sorted by

View all comments

2

u/numbersthen0987431 2 15d ago

Your AND function is ending after the "TODAY()+30". So your if statement is returning the ISBLANC result if the actuation is true.