Excel技术咨询：如何按条件在Matriculated列显示指定文本

Got it, let's break down the exact formula you need to populate your Matriculated column based on those three rules. I'll cover two approaches—one for newer Excel versions (365/2021) that's cleaner, and a nested IF version for older Excel that works everywhere.

First, let's assume:

• Your admission status is in column B (e.g., cell B2 has "Admitted" for the first applicant)
• Your deposit payment status is in column C (e.g., cell C2 has "Paid" when the deposit is received)

Option 1: IFS Function (Excel 365/2021+) #

This is the most readable approach since it lets you list each condition directly with its result:

=IFS(AND(B2="Admitted", C2="Paid"), "Enrolling", AND(B2="Admitted", C2<>"Paid"), "Not Enrolling", TRUE, "Not Admitted")

How it works:

• The first AND checks if the applicant is both admitted and has paid the deposit — returns "Enrolling" if true
• The second AND checks if they're admitted but haven't paid (adjust C2<>"Paid" to match your actual "unpaid" value, like C2="Unpaid" if that's how you track it) — returns "Not Enrolling"
• The final TRUE acts as a catch-all for every other scenario (not admitted, invalid statuses, etc.) — returns "Not Admitted"

Option 2: Nested IF Function (All Excel Versions) #

If you're using an older Excel version that doesn't support IFS, use nested IFs instead:

=IF(AND(B2="Admitted", C2="Paid"), "Enrolling", IF(AND(B2="Admitted", C2<>"Paid"), "Not Enrolling", "Not Admitted"))

How it works:

• We start with the most specific condition first (admitted + paid)
• If that's false, we check the next condition (admitted but not paid)
• If both are false, we default to "Not Admitted"

Quick Notes: #

• Make sure to replace B2 and C2 with the actual cell references from your spreadsheet
• Double-check that the text values ("Admitted", "Paid") match exactly what's in your data — Excel ignores case, but spelling/typos will break the formula!

内容的提问来源于stack exchange，提问作者Jillian McCarthy