Fix Excel IFS Formulas Returning the Same Result When Filled Down
Question details
The user needs to fix an IFS or comparison formula that returns the same result in every row after it is filled down.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A comparison formula evaluates values in columns AT and AS and is copied down multiple rows.
- Observed behavior
- Filled-down formulas display a repeated result instead of correctly showing Below, Met, or Above for each row.
Select a few affected cells and confirm that each filled-down formula refers to the matching row, such as AT3 and AS3, then AT4 and AS4. Check the values in the compared cells for leading spaces, apostrophes, or text formatting.
Set Excel calculation mode to Automatic
Use this when formulas remain unchanged or keep showing an old repeated result after you fill them down.
In Excel, select the Formulas tab and choose Calculation Options.
Select Automatic, then press F9 or choose Formulas > Calculate Now to refresh the worksheet.
Click the first formula cell and drag or double-click its fill handle to copy the formula down the target rows again.

Convert text-formatted comparison values to numbers
Use this when cells look like numbers but comparisons return unexpected or identical results.
Remove hidden characters and use a row-based comparison formula
Use this when copied data contains invisible spaces or nonprinting characters, or when you need a reliable Below, Met, and Above formula.
Compare Spreadsheet Values with IFS or IF in WPS Spreadsheet
WPS Spreadsheet lets you create and fill comparison formulas, refresh calculations, and clean imported values so each row can return Below, Met, or Above correctly.
- 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, choose Spreadsheets, and open the Excel .xlsx or .xls file containing the comparison columns.
- 2. Check calculation settings: Go to the Formulas tab and set Calculation Options to Automatic, then use Calculate Now if the values do not refresh.
- 3. Enter a comparison formula: In the first result cell, type =IFS(AT3<AS3,"Below",AT3=AS3,"Met",TRUE,"Above") or use the nested IF alternative.
- 4. Fill the formula down: Select the formula cell and drag the fill handle down the results column so every row uses its own AT and AS references.

Frequently Asked Questions
Why does my IFS formula show the same answer in every row?
The workbook may be in Manual calculation mode, or the compared values may be text rather than real numbers. In Excel, go to Formulas > Calculation Options > Automatic and then check columns AT and AS for text-formatted numbers.
What formula compares AT3 with AS3 and returns Below, Met, or Above?
Use =IFS(AT3<AS3,"Below",AT3=AS3,"Met",TRUE,"Above"). If IFS is not available, use =IF(AT3<AS3,"Below",IF(AT3=AS3,"Met","Above")).
How can I tell whether numbers are stored as text in Excel?
Select the cells and look for a green error indicator or a Convert to Number option. You can also use =ISNUMBER(AT3); FALSE indicates that the value is not stored as a numeric value.
Can hidden spaces affect Excel comparison formulas?
Yes. Leading, trailing, and nonprinting characters can cause comparisons to fail. Use TRIM to remove extra spaces and CLEAN to remove nonprinting characters, then convert the cleaned result to a number with VALUE when needed.
Why do formula references matter when filling down?
Relative references should change by row when copied down. Verify that the first formula uses AT3 and AS3, while the next row uses AT4 and AS4. Use dollar signs only when a reference must remain fixed.




