Function Problems

Create an Excel Formula Based on Two Yes or No Results in WPS Spreadsheets

Phi Hung Vo Nov 13, 2026 869 views

Question details

Create a formula or conditional formatting rule to evaluate whether two cells in the same column both contain Yes, then display a Good or Bad result.

Create an Excel Formula Based on Two Yes or No Results in WPS Spreadsheets

Product: WPS Spreadsheets
Device & OS: not provided
Scenario: The user is building a worksheet and needs to check two source cells, such as E6 and E9, and show Good when both are Yes and Bad otherwise.
Observed behavior: A result should appear as Good when both cells contain Yes and Bad when the condition is not met.

Before you start

Open the workbook in WPS Spreadsheets and identify the two source cells and the result cell in the same column before entering the formula.

Solution 1Recommended

Use IF and AND to Return Good or Bad

Best for a compact result in one cell; use this when you need a single Good/Bad value based on two Yes cells.

The AND function returns TRUE only when both tests are TRUE. IF then returns Good for TRUE and Bad for FALSE.

Select the result cell

Click the cell where you want Good or Bad to appear, such as E11 or another result cell in the same column.

Enter the IF and AND formula

Type =IF(AND(E6="Yes",E9="Yes"),"Good","Bad") into the formula bar or directly into the cell and press Enter.

Copy the formula to other columns

Use the fill handle to drag the formula across the result row so each column checks its own two source cells.

Formula ready: The IF and AND formula updates automatically when E6 or E9 changes.

Solution 2

Apply Conditional Formatting to Highlight Good and Bad

Use this to make the result row easier to scan by showing Good in green and Bad in red.

WPS Spreadsheets

Create a Two-Yes Formula in WPS Spreadsheets

In WPS Spreadsheets, use the built-in IF and AND functions to check two cells and return Good or Bad, then add conditional formatting so the result is easy to read.

1. Open your workbook in WPS Spreadsheets: Launch WPS Office and open the workbook that contains the two Yes/No source cells and the result cell.
2. Select the result cell: Click the cell where you want the Good or Bad result to appear, for example E11 or another cell in the same column.
3. Enter the IF and AND formula: Type =IF(AND(E6="Yes",E9="Yes"),"Good","Bad") and press Enter.
4. Copy the formula across columns: Drag the fill handle across the result row so the formula adjusts for each column automatically.
5. Format Good and Bad visually: Select the result row, go to Home > Conditional Formatting, and create rules to color Good green and Bad red.

Uses the same Excel formula syntax you already know, so there is no learning curveReads and saves .xlsx files with full Microsoft Excel compatibilityIncludes built-in conditional formatting to color Good and Bad instantlyRuns free in WPS Office with a familiar ribbon interface

Frequently Asked Questions

Can I copy this formula across multiple columns?

Yes. If you use relative references like E6 and E9, dragging the fill handle to the next column automatically changes them to F6 and F9.

What should I do if my Yes cells contain spaces, such as ' Yes '?

Use TRIM in the formula, for example =IF(AND(TRIM(E6)="Yes",TRIM(E9)="Yes"),"Good","Bad"), to ignore extra spaces.

How do I make Good appear green and Bad appear red?

Select the result cells, go to Home > Conditional Formatting > Highlight Cells Rules > Equal To, enter Good and choose a green fill; repeat for Bad with red.

Can I return values other than Good and Bad?

Yes. Replace Good and Bad in the IF formula with the text or numbers you want, such as Approved and Review.

Excel & Data Problems