Why an Excel IFS Formula Returns FALSE for a City
Question details
Find out why a city is not producing the expected percentage in an Excel IFS formula.

- 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.
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.
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.
Select the city cell, such as B17, and check the formula bar for leading or trailing spaces. Retype Akron if needed.
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.
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.
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.

Replace the long IFS formula with a city lookup table
Use a lookup table when city names or percentages need regular updates.
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. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Build the lookup table: Enter city names in D2:D10 and their percentages in E2:E10, adjusting the range for your list.
- 3. Enter the formula: Select the result cell and enter =IFERROR(VLOOKUP(TRIM(B17),$D$2:$E$10,2,FALSE),"Not found").
- 4. Test and save: Enter a listed city in B17, check the returned percentage, and select Save to keep the changes.

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.




