Formula Errors

Fix an Excel IF Formula for Met, Not Met, and None

Maira MehtabMaira Mehtab Nov 18, 2026 869 views

Question details

Return Y or N based on whether a cell contains Met, Not Met, or None.

Fix an Excel IF Formula for Met, Not Met, and None
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet needs to convert status text into a Y or N result.
Observed behavior
Met and None should return Y, Not Met should return N, and empty or unexpected values should return a blank.
Before you start

Identify the cell containing the status and an empty cell for the result. The example uses A20 for the status and B20 for the formula.

Solution 1Recommended

Use IF and OR to check the status in Excel

Use this formula to map the three expected statuses while leaving other values blank.

1
Select the result cell

In Excel, click B20 or another empty cell where you want the Y or N result.

2
Enter the formula

Type =IF(A20="","",IF(OR(A20="Met",A20="None"),"Y",IF(A20="Not Met","N",""))) and press Enter. Replace A20 with your status cell if needed.

3
Check the results

Enter Met, None, and Not Met in A20 to verify that B20 returns Y, Y, and N respectively. Clear A20 or enter another value to check that the result is blank.

4
Apply it to other rows

Select B20 and drag its fill handle down the column to adjust the cell references for each row.

Use IF and OR to check the status in Excel
Check spaces in status text: The status values must match the formula text without extra spaces. Excel's text comparisons are not case-sensitive.
Work with status formulas

Create the same status formula in WPS Spreadsheets

Use IF and OR in WPS Spreadsheets to convert Met, None, and Not Met into Y or N, then fill the formula down your worksheet.

  1. 1. Open the worksheet: Open WPS Spreadsheets and select Open to load your workbook, or create a new spreadsheet.
  2. 2. Enter a status: Click A20 and enter Met, None, or Not Met, or identify the cell that already contains the status.
  3. 3. Add the formula: Click B20 and enter =IF(A20="","",IF(OR(A20="Met",A20="None"),"Y",IF(A20="Not Met","N",""))), then press Enter.
  4. 4. Fill and save: Drag the fill handle on B20 down to apply the formula to other rows, then select Save to save the workbook.
Map status text to Y or N with familiar IF and OR functionsOpen and save Microsoft Excel XLSX filesFill formulas down a column for multiple recordsUse a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

What does the formula return for an empty cell?

It returns an empty string, so the result cell appears blank. The first IF checks whether A20 is empty.

Why is my status returning a blank instead of Y or N?

Check the status cell for extra spaces or a value other than Met, None, or Not Met. Unexpected values return a blank.

Does the formula distinguish between uppercase and lowercase?

No. Excel's text comparisons are not case-sensitive, so met and Met both match "Met".

How do I use the formula for an entire column?

Enter the formula beside the first status, then drag the result cell's fill handle down. The relative reference changes for each row.