Function Problems

WPS Spreadsheet IF Formula to Return $0.00 or Another Cell's Value

Aamir Naveed Akram Nov 12, 2026 869 views

Question details

The user needs an IF formula that returns zero when two cells match and otherwise returns the value from another cell.

Product: WPS Spreadsheet
Device & OS: not provided
Scenario: The formula is needed in cell I18 to compare I17 with F25 and return the value in F33 when the comparison is false.
Observed behavior: The desired result is a numeric 0 when I17 equals F25, displayed as $0.00, or the value from F33 when they do not match.

Before you start

Check that I17 and F25 contain comparable values and that F33 contains the fallback result. Select I18 and make sure the formula bar is available before entering the formula.

Solution 1Recommended

Use an IF formula and apply two-decimal currency formatting

Use this solution when I18 should return zero for a match and the value in F33 when the cells differ.

The IF function tests whether I17 equals F25. It returns 0 when the condition is true and returns the value in F33 when the condition is false. Currency formatting changes the displayed zero to $0.00 without changing the underlying numeric value.

Select the result cell

Open the worksheet in WPS Spreadsheet and select cell I18.

Enter the IF formula

Type =IF(I17=F25,0,F33) in the formula bar or directly in cell I18, then press Enter.

Apply currency formatting

Select I18, open the Home tab, choose the Currency format in the Number group, and set the decimal places to 2 if needed.

Expected result: I18 displays $0.00 when I17 equals F25; otherwise, it displays the value stored in F33.

WPS Spreadsheet formula tools

Create conditional currency results with WPS Spreadsheet

WPS Spreadsheet lets you enter the IF formula directly in the target cell, compare values across the worksheet, return a fallback cell value, and format the result as currency.

1. Open the spreadsheet: Launch WPS Office and open the workbook in WPS Spreadsheet.
2. Select I18: Click cell I18, the cell where the conditional result should appear.
3. Enter the formula: Type =IF(I17=F25,0,F33) and press Enter.
4. Format the result: Use Home > Currency and set the number format to two decimal places.

Build conditional zero-or-cell-value results with the IF functionApply $ currency formatting with two decimal placesEdit formulas directly from the formula bar and reuse them across compatible worksheetsOpen and save Microsoft Excel .xlsx files with familiar spreadsheet tools

microsoft office alternative - wps office

Frequently Asked Questions

What formula returns zero when I17 matches F25?

Enter =IF(I17=F25,0,F33) in cell I18. The formula returns 0 when the two cells match and returns F33 otherwise.

How can I display the zero as $0.00?

Select I18, go to the Home tab, choose Currency in the Number group, and set the decimal places to 2.

Will the formula return the value from F33 when I17 and F25 differ?

Yes. The third argument of the IF function is F33, so the value in F33 is returned whenever I17 is not equal to F25.

Can I use this formula in another row or column?

Yes. Copy the formula to another cell, but review the references after copying because relative references such as I17 and F33 may adjust automatically.

Excel & Data Problems