How to Enable or Disable an Excel Hyperlink with IF in WPS Office
Question details
The user wants to create an Excel hyperlink that is active only when a specified condition is met and returns blank or another value when the condition is not met.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is building a worksheet with navigation links that should appear conditionally, such as when a status, value, or input meets a rule.
- Observed behavior
- The desired behavior is an active hyperlink to another worksheet when the logical test is TRUE and a blank or alternative value when it is FALSE.
Verify the target worksheet exists and note the exact sheet name and destination cell you want to open. Identify the condition cell or expression that controls when the hyperlink should be active.
Create a Conditional Hyperlink with IF and HYPERLINK
Use this formula when the hyperlink should appear only after a condition is met and disappear or show another value when it is not.
The IF function decides which value to display. When the condition is TRUE, HYPERLINK creates an active worksheet link; when FALSE, the formula returns the value in the third argument, such as an empty string.
Open the workbook in WPS Office Spreadsheets and click the cell where the conditional hyperlink should appear.
Type =IF(logical_test,HYPERLINK("#Sheet2!A1","Open sheet"),"") and replace logical_test with the condition, #Sheet2!A1 with the target sheet and cell, and "Open sheet" with the link text.
Press Enter. If the condition is TRUE, the cell displays the active hyperlink; if FALSE, it returns the value specified in the IF formula.
Change the condition cell or input and confirm the hyperlink appears or disappears as expected.
Use IF and HYPERLINK to Create Conditional Hyperlinks in WPS Office Spreadsheets
WPS Office Spreadsheets supports the same IF and HYPERLINK functions as Excel, so you can make a hyperlink active only when a condition is met and return a blank or custom value when it is not.
- 1. Open WPS Office: Download and open WPS Office, then load the Excel workbook in WPS Office Spreadsheets.
- 2. Select the target cell: Click the cell where you want the conditional hyperlink to appear.
- 3. Enter the formula: Type =IF(logical_test,HYPERLINK("#Sheet2!A1","Open sheet"),"") and adjust the condition, sheet, and cell references.
- 4. Apply and test: Press Enter and change the condition input to verify that the hyperlink is enabled or disabled as expected.
Frequently Asked Questions
Can I make a hyperlink appear only when a cell equals a specific value?
Yes. Use a formula like =IF(A1="Yes",HYPERLINK("#Sheet2!A1","Open sheet"),""). The link only appears when A1 contains "Yes".
What should I use for the link location when linking to another worksheet?
Use the sheet name and cell in the format "#Sheet2!A1". Include the quotes and use the exact sheet name from WPS Office Spreadsheets.
What can I display when the condition is false?
The third argument of IF can be an empty string "" for a blank cell, or another value such as "Not available".
Does the HYPERLINK function work the same in WPS Office and Microsoft Excel?
Yes. WPS Office Spreadsheets supports IF and HYPERLINK with the same syntax, so formulas created in Excel can work in WPS Office and vice versa.
