How to Use Cells from Another Worksheet in an AND Formula in WPS Office Spreadsheets
Question details
The user needs to write an AND formula in WPS Office Spreadsheets that references cells from a previous worksheet and returns TRUE or FALSE correctly with the proper argument separator.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is creating a condition check that must evaluate cells located on another worksheet.
- Observed behavior
- The AND formula should return TRUE when all referenced cells meet the condition and FALSE otherwise.
Before writing the formula, verify the exact sheet name and whether your regional version of WPS Office Spreadsheets uses commas or semicolons as the argument separator.
Use a Direct AND Formula with a Previous Worksheet Reference
Use this solution when you want a compact TRUE/FALSE check that reads cells from a previous worksheet without wrapping the formula in IF.
The AND function already returns TRUE or FALSE, so there is no need to wrap it in IF.
Use the previous worksheet tab name followed by an exclamation mark before each cell reference.
Open the workbook in WPS Office Spreadsheets and click the cell where you want the TRUE/FALSE result to appear.
Type =AND(, click the previous worksheet tab such as Tab_1, select cell A1, type a comma or semicolon according to your regional list separator, then repeat for A2 and A3 and close the parenthesis: =AND(Tab_1!A1>=10,Tab_1!A2>=10,Tab_1!A3>=10).
Press Enter and confirm the cell returns TRUE only when all three cells are greater than or equal to 10, or FALSE otherwise.
Use Semicolon Separators for Regional Settings
Use this solution if the comma-separated formula causes an error because your WPS Office Spreadsheets version requires semicolons as the argument separator.
Create Cross-Sheet AND Formulas in WPS Office Spreadsheets
WPS Office Spreadsheets lets you reference another worksheet directly in an AND formula. Use the built-in formula bar, adjust the list separator to your regional settings, and get TRUE/FALSE results without wrapping the formula in IF.
- 1. Open the Excel-compatible workbook: Open your xlsx workbook in WPS Office Spreadsheets and go to the worksheet where the result should appear.
- 2. Insert the AND formula: Click the result cell, type =AND(, click the previous worksheet tab such as Tab_1, and select the referenced cells A1, A2, and A3 or type their addresses.
- 3. Set the correct list separator: Use commas or semicolons between arguments depending on your regional settings: =AND(Tab_1!A1>=10,Tab_1!A2>=10,Tab_1!A3>=10).
- 4. Confirm and evaluate: Press Enter and verify that WPS Spreadsheets returns TRUE only when all referenced cells meet the condition.
Frequently Asked Questions
Why does my AND formula return #NAME? when I reference another sheet?
A #NAME? error usually means WPS Office is using a localized function name or the wrong list separator. Use the English function name AND and set commas or semicolons according to your regional settings.
Do I need to wrap the AND function in IF to get TRUE or FALSE?
No. The AND function already returns TRUE or FALSE, so you can use =AND(Tab_1!A1>=10,Tab_1!A2>=10,Tab_1!A3>=10) directly.
How do I reference a sheet name that contains spaces in the formula?
Wrap the sheet name in single quotes, for example =AND('Previous Sheet'!A1>=10,'Previous Sheet'!A2>=10).
How do I know whether to use commas or semicolons in WPS Office?
Enter a simple formula such as =SUM(1,2). If you get a #NAME? error, replace the comma with a semicolon, or check the regional language/locale settings that control list separators.
Can I use cells from a previous worksheet in WPS Office on Windows and mobile?
Yes, cross-sheet references work in WPS Office Spreadsheets on desktop and mobile, but the exact list separator may vary depending on your system locale.
