# Nestef if greater than, less than help!

1. ## Nestef if greater than, less than help!

Hi, i am trying to solve this all morning, any help is appreciated:

I have three conditions:

from 1 to 12000
from 12001 to 34999
from 35000 and above

And i am trying to tell excel that

IF the cell O35 is 1 to 12000 then 15% IF the cell O35 is from 12001 to 34999 then 35% IF the cell O35 is greater than 35000 then 45%

or to say it another way

IF the cell O35 is greater than 1 but less than 12000 then 15% IF the cell O35 is greater than 12001 but less than 34999 then 35% IF the cell O35 is greater than 35000 then 45%

But i fail miserably!!! This is for tax purposes! Can someone kindly assist?

2. ## Re: Nestef if greater than, less than help!

Try: =if(o35 < =12000,0.15,if(and(o55 > 12000,o35 < 35000),0.35,0.45))

3. ## Re: Nestef if greater than, less than help!

WILL YOU MARRY ME!!!! Worked!

4. ## Re: Nestef if greater than, less than help!

An alternative:

=LOOKUP(O35,{1,12001,35000},{0.15,0.35,0.45})

5. ## Re: Nestef if greater than, less than help!

Originally Posted by Glenn Kennedy
An alternative:

=LOOKUP(O35,{1,12001,35000},{0.15,0.35,0.45})
Also works!

6. ## Re: Nestef if greater than, less than help!

You're welcome.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

7. ## Re: Nestef if greater than, less than help!

Done and done!

There are currently 1 users browsing this thread. (0 members and 1 guests)