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.
A variant with XLOOKUP and a dedicated lookup table.
=XLOOKUP(D2,city,rate,"Enter Sales Tax Rate")