Fix an Excel Multiplication Formula Returning Zero After Filling Down
Question details
The user needs to determine why a multiplication formula displays $0.00 in later rows after being filled down.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A formula multiplies values in columns F and H and is filled down a currency-formatted column.
- Observed behavior
- The first cells show the expected result, but later rows display $0.00.
Identify a row that displays $0.00 and check the values in columns F and H. Select the result cell so you can inspect its formula in the formula bar.
Check the Filled Formula and Its Source Cells
Use this method to verify that each formula points to the intended row and that its input cells contain the expected values.
SUM is unnecessary when multiplying two cells: =SUM(F2*H2) and =F2*H2 produce the same result for the same inputs. Removing SUM makes the formula simpler but does not by itself fix a zero result.
Select the first result cell, enter =F2*H2 in the formula bar, and press Enter.
Select the result cell and drag its fill handle down through the remaining rows.
Select a cell showing $0.00 and check the formula bar. For example, the formula in row 10 should refer to F10 and H10 if both inputs should come from that row.
Select the referenced cells in columns F and H and verify that they contain the intended values. A blank or zero input can produce a zero result.

Check Currency Rounding and Calculation Settings
Use these checks if the references and inputs appear correct but the displayed result is still $0.00.
Multiply and Check Filled Formulas in WPS Spreadsheet
Use WPS Spreadsheet to multiply values, fill formulas down, and inspect results that appear as zero.
- 1. Open the workbook: Open WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Enter the formula: Select the first result cell, type =F2*H2 in the formula bar, and press Enter.
- 3. Fill down: Select the formula cell and drag its fill handle down the result column.
- 4. Check zero results: Select a cell displaying $0.00, inspect its references in the formula bar, and check the referenced input cells. Use the Home tab's decimal controls to reveal any small nonzero result.

Frequently Asked Questions
Does removing SUM fix a multiplication formula that returns zero?
Not necessarily. =SUM(F2*H2) and =F2*H2 calculate the same product. Check the filled references and the values in the source cells if the result is still zero.
Why does a result display $0.00 when it is not exactly zero?
Currency formatting can round a small result to two decimal places. Select the cell and use Home > Increase Decimal to display more digits.
How can I check whether a filled formula references the right row?
Select an affected result cell and look at the formula bar. If both inputs should come from the same row, a formula in row 10 should reference F10 and H10.
What if Excel is not recalculating the formulas?
Go to Formulas > Calculation Options and select Automatic. Then choose Calculate Now on the Formulas tab.




