multiple if/then statement

**Mile029** · 02-06-2013, 02:35 PM

I want a formula that will give different results based on what's in one cell. For example, if e39>5,000, then give me "1", if greater than 12,000, give me "2",if greater than 20,000, give me "3", if less then 5,000, give me "0". Is there a simple way to do this?

**Moo the Dog** · 02-06-2013, 02:38 PM

You can try this:

=LOOKUP(E39,{-2.2251E-308,5000,12000,20000},{0,1,2,3})

- Moo

**Pete_UK** · 02-06-2013, 02:38 PM

Try this:

=IF(E39<5000,0,IF(E39<12000,1,IF(E39<20000,2,3)))

Hope this helps.

Pete

**Andrew-R** · 02-06-2013, 02:39 PM

Something like this, perhaps:

=IF(E39<5000,0,IF(E39<12000,1,IF(E39<20000,2,3)))

Although you don't specify the result if E39 is exactly equal to any of your values, and if it is is greater than 20,000 then it will also be greater than 12,000.