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

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((B21000),A,IF((B22000),B,IF((B23000),C,IF( (B24000),D,""))))*</blockquotenow
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?


--
philo351
------------------------------------------------------------------------
philo351's Profile: http://www.excelforum.com/member.php...o&userid=30295
View this thread: http://www.excelforum.com/showthread...hreadid=499621