Formula Errors

Why an Excel IFS Formula Returns FALSE for a City

Bushra ParveenBushra Parveen Nov 18, 2026 869 views

Question details

Find out why a city is not producing the expected percentage in an Excel IFS formula.

Why an Excel IFS Formula Returns FALSE for a City
Product
Microsoft Excel
Device & OS
not provided
Scenario
An IFS formula checks a city name and returns a corresponding percentage.
Observed behavior
One city returns FALSE or does not produce the expected percentage.
Before you start

Select the formula cell and inspect the formula bar to identify the city input cell and its condition-result pairs. Check which percentage should apply to each city, including Warrensville Heights.

Solution 1Recommended

Check the city text and complete the IFS conditions

Use this approach to correct the existing formula and identify cities that do not match any condition.

Each IFS condition must be followed by its result. A duplicated Akron condition is unnecessary; if both match, IFS returns the result of the first one.

IFS normally returns #N/A when no condition is TRUE, not FALSE. A FALSE result may come from a result argument or another part of the formula.

1
Inspect the city name

Select the city cell, such as B17, and check the formula bar for leading or trailing spaces. Retype Akron if needed.

2
Review each condition and result

Select the IFS formula cell and check the formula bar. Add a condition and percentage for any missing city, such as Warrensville Heights, and remove redundant Akron conditions.

3
Add a fallback

Add TRUE,"Not found" as the final condition-result pair. For example, =IFS(TRIM(B17)="Akron",5%,TRIM(B17)="Warrensville Heights",7%,TRUE,"Not found") uses TRIM to remove ordinary extra spaces. Replace the example percentages with the correct values.

4
Test the formula

Enter each city in B17 and confirm that the formula cell returns the intended percentage. Enter an unlisted city to verify that it returns Not found.

Check the city text and complete the IFS conditions
Check for nonbreaking spaces: TRIM does not remove nonbreaking spaces. If copied city names still do not match, try TRIM(SUBSTITUTE(B17,CHAR(160)," ")) in the comparison.
Work with city lookups in WPS

Look up city percentages in WPS Spreadsheets

Use a city lookup table and VLOOKUP in WPS Spreadsheets to return percentages without maintaining a long list of formula conditions.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Build the lookup table: Enter city names in D2:D10 and their percentages in E2:E10, adjusting the range for your list.
  3. 3. Enter the formula: Select the result cell and enter =IFERROR(VLOOKUP(TRIM(B17),$D$2:$E$10,2,FALSE),"Not found").
  4. 4. Test and save: Enter a listed city in B17, check the returned percentage, and select Save to keep the changes.
Maintain city names and percentages in one tableUse exact-match VLOOKUP for city-based ratesOpen and edit Microsoft Excel XLSX and XLS filesWork in a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Why does my IFS formula return #N/A instead of a percentage?

IFS returns #N/A when none of its conditions is TRUE. Check the city spelling and conditions in the formula bar, then add a final pair such as TRUE,"Not found".

Does listing Akron twice change the IFS result?

IFS returns the result for the first TRUE condition. A second Akron condition will not be reached when the first matches, so remove the duplicate to make the formula easier to maintain.

How can I find extra spaces in a city name?

Select the city cell and inspect its contents in the formula bar. Use TRIM(B17) in a comparison to remove ordinary leading, trailing, and repeated spaces.

What if a city is missing from the formula?

Add the city and its percentage as a condition-result pair before the final TRUE fallback. Alternatively, add the city and percentage as a new row in your lookup table.