Nested If/Then statements
qwik
You kinda got it backwards.
If all values are <500 then you will always get "V"
Start with the lowest value.
=IF(B4<=100,"Z",IF(B4<=200,"Y",IF(B4<=300,"X",IF(B 4<=400,"W",IF(B4<=500,"V")))))
Gord Dibben Excel MVP
On Thu, 8 Dec 2005 20:27:08 -0600, qwik6
wrote:
Hello Everyone,
I sure could use a little help. I started with this If/Then statement
and it seems to get hung at what I understand to be the 1st "test".
I'm not sure what I'm doing wrong here......I'm loading this statement
for 8 different values (all under 500) and its supposed to bring back a
response for each value, but all it lists is the V. Any help would be
appreciated.
=IF(B4<=500,"V",IF(B4<=400,"W",IF(B4<=300,"X",IF( B4<=200,"Y",IF(B4<=100,"Z","")))))
|