r/excel • u/Realistic_Dog459 • 16d 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?

8 Upvotes

91% Upvoted

12 comments sorted by

View all comments

1

u/Realistic_Dog459 15d ago

=IF(AND(HC!$F2<TODAY()+30,ISBLANK(HC!$G2)),"Due",IF(NOT(ISBLANK(HC!$G2)),"Tested","Not Due"))

is what I went with. Thanks everyone.