CODEWITHSUNDEEP
excelexcel-formula
Justin T
Justin T

Reputation: 1

excel if statement having a range in a single cell

At the moment I am working on using on implementing nested if statement in excel for a project. It involves calculating the tax of employees using a tax table and would like to know if it possible for a logical test to distinguish a range within a singular cell i.e $0-$18,000

Upvotes: 0

Views: 55

Answers (2)

Nitesh Halai
Nitesh Halai

Reputation: 927

If you are open to using VLOOKUP, you can create a table showing the range and the associated value with it and use vlookup with the last argument being TRUE (approximate match) to get the value.

enter image description here

This is the output:

 1.00        10%
 100,000.00  30%
 40,000.00   25%
 17,999.00   10%
 18,000.00   10%
 18,001.00   15%

Upvotes: 1

bzimor
bzimor

Reputation: 1628

Try nested IF and AND formulas in combination. For example, there are three ranges: 0-18 000, 18 000- 23 000, 23 000<, then use this:

=IF(AND(A1>=0, A1<=18000),"range 1",IF(AND(A1>18000, A1<=23000),"range 2","range 3"))

Upvotes: 0

Related Questions