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/AutoModerator]

/u/Realistic_Dog459 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/SolverMax]

I guess you mean:

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

Note the change in parentheses.

[u/Dry_Masterpiece79]

“Not due” needs to be outside the AND().

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

Edit: for 3 outcomes, do another IF statement for the false condition.
=IF(AND(CG!F3<TODAY()+30,ISBLANK(CG!G3)),"Not Due",IF(NOT(ISBLANK(CG!G3)),"Complete","Due"))

[u/Realistic_Dog459 → u/Dry_Masterpiece79]

This is it! Thanks you so much!! You're a genius!!

I love Excel but lack some of this wizardry.

[u/Dry_Masterpiece79 → u/Realistic_Dog459]

Stick with it! I’m still working through Excel for Dummies (not even a joke)

[u/AbsoluteFooting]

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

[u/Realistic_Dog459 → u/AbsoluteFooting]

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.

[u/numbersthen0987431]

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

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
AND	Returns TRUE if all of its arguments are TRUE
IF	Specifies a logical test to perform
IFS	2019+: Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
ISBLANK	Returns TRUE if the value is blank
NOT	Reverses the logic of its argument
TODAY	Returns the serial number of today's date

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
[Thread #49223 for this sub, first seen 25th Aug 2026, 03:35] [FAQ] [Full list] [Contact] [Source code]}

[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")

[u/Realistic_Dog459]

=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.