IF/WHEN forumla fo when a cell is between two numbers

P

philo351

I'm trying to use a multiple "multiple" IF/WHEN formula for when a
number falls between two numbers. For example, if a number falls
anywhere between 1000 and 1999, then I need result A. If the number
falls between 2000 and 2999, then I need result B. For anything falling
between 3000-3999, I need result B ...etc.

Currently I'm hoping to apply this to a multiple IF/WHEN forumula which
is as follows
<blockquote>
*=IF((B2>1000),A,IF((B2>2000),B,IF((B2>3000),C,IF((B2>4000),D,""))))*</blockquote>now
obviously this isn't going to work. I need each condition to apply to a
range between two numbers which would operate this
way<blockquote>*=IF((<font color="red">B2 is between 1000 and
2999</font>),A,IF((<font color="red">B2is between 2000 and
2999</font>),B,IF((<font color="red">B2is between 3000 and
3999</font>),C,IF((<font color="red">B2 is between 4000 and
4999</font>),D,""))))*</blockquote>

any ideas? do I need to write a VBA script for this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF/WHEN forumla fo when a cell is between two numbers 1
IF/WHEN forumla fo when a cell is between two numbers 4
Formula to count data in a column that falls between a range 3
Formula help 1
LOOKUP or IF-THEN stmt - which one? 8
Between Two Numbers... 2
Using Three Conditions in CF 3
Reference function from an out of sort table 5

Top