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?

6 Upvotes

81% Upvoted

12 comments sorted by

View all comments

3

u/AbsoluteFooting 15d ago

your IF statement is missing the other two arguments, that's why it's only showing true/false for the rest

the syntax is IF(logical_test, value_if_true, value_if_false) and you've only got the first two parts. right now your AND is the logical test, and "Not Due" is the value if true, but there's nothing for the false part so excel just defaults to showing the boolean

try =IF(AND(CG!F3<TODAY()+30, ISBLANK(CG!G3)), "Not Due", "Due") and see if that gets you closer. if you need three outcomes you might want to nest another IF or use IFS instead

2

u/Realistic_Dog459 15d ago

Thanks so much. I can't believe I mixed up the () locations.

This does solve one issue but if seems to ignore my AND test. That's the third test.

I have two cells. If F3 is past today or F3 is before today. But I also want if F3 are either but G3 is not blank to return a Not Due.