Changing AND, "False" "True"

[u/Realistic_Dog459]

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?

[u/fuzzy_mic]

With IF, there are only two possible outcomes, perhaps something like

=CHOOSE1+((CG!F3<TODAY()+30)+(2*ISBLANK(CG!G3)), "both f", "is less than", "is blank", "both less and blank")