Forum Discussion
Solved
IFS Function Multiple Criteria
I am trying to write an IFS formula (for a tax spreadsheet) where I type in the name of a city and it automatically enters the sales tax rate for that particular locality. Here is an example: If...
=IFS(A1="Elyria",6.5%,A1= "Cleveland", 8%, A1="West Salem", 6.5%, A1="Hudson", 6.75%, A1="Toledo", 7.75%, TRUE, "Enter Sales Tax Rate")You can try this formula.
=IFS(A1="Elyria",6.5%,A1= "Cleveland", 8%, A1="West Salem", 6.5%, A1="Hudson", 6.75%, A1="Toledo", 7.75%, TRUE, "Enter Sales Tax Rate")You can try this formula.
- I left it as IFS (Because I didn't see it was changed to WENNS until just now) and put in the A1 before each city and it worked perfectly! Thank you so much!
