Fix an Excel IF Formula for Met, Not Met, and None
Question details
Return Y or N based on whether a cell contains Met, Not Met, or 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.
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.
Use IF and OR to check the status in Excel
Use this formula to map the three expected statuses while leaving other values blank.
In Excel, click B20 or another empty cell where you want the Y or N result.
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.
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.
Select B20 and drag its fill handle down the column to adjust the cell references for each row.

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. Open the worksheet: Open WPS Spreadsheets and select Open to load your workbook, or create a new spreadsheet.
- 2. Enter a status: Click A20 and enter Met, None, or Not Met, or identify the cell that already contains the status.
- 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. Fill and save: Drag the fill handle on B20 down to apply the formula to other rows, then select Save to save the workbook.

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.




