Remember Me? December 9th 05, 03:27 AM posted to microsoft.public.excel.worksheet.functions
 qwik6 Posts: n/a Nested If/Then statements

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".
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(B 4<=200,"Y",IF(B4<=100,"Z","")))))

--
qwik6
------------------------------------------------------------------------
qwik6's Profile: http://www.excelforum.com/member.php...o&userid=29502 December 9th 05, 03:50 AM posted to microsoft.public.excel.worksheet.functions
 duane Posts: n/a Nested If/Then statements

it will return V for any value in b4 <= 500 - you need to invert it to
get what you want

=IF(B4<=500,"V",IF(B4<=400,"W",IF(B4<=300,"X",IF(B
4<=200,"Y",IF(B4<=100,"Z","")))))

=IF(B4<=100,"Z",IF(B4<=200,"Y",IF(B4<=300,"X",IF(B 4<=400,"W",IF(B4<=500,"V","")))))

will return for B\$

Z <=100
Y 100<B4<=200
X 200<B4<=300
W 300<B4<=400
V 400<B4<=500
"" anything else

--
duane

------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 December 9th 05, 03:54 AM posted to microsoft.public.excel.worksheet.functions
 Gord Dibben Posts: n/a Nested If/Then statements

qwik

You kinda got it backwards.

If all values are <500 then you will always get "V"

=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".
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",""))))) December 9th 05, 04:38 AM posted to microsoft.public.excel.worksheet.functions
 qwik6 Posts: n/a Nested If/Then statements

Thanks everyone, I really appreciate the help. Your info helped get me
over that hurdle. It sometimes sucks when you're trying to teach
yourself without anyone to work with.

--
qwik6
------------------------------------------------------------------------
qwik6's Profile: http://www.excelforum.com/member.php...o&userid=29502

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On Similar Threads Thread Thread Starter Forum Replies Last Post RRS from Connecticut Excel Discussion (Misc queries) 7 September 23rd 05 07:35 PM John Simons Excel Worksheet Functions 14 February 16th 05 07:17 AM Richard-44 Excel Worksheet Functions 2 January 6th 05 03:19 AM Steven Excel Worksheet Functions 1 January 5th 05 10:52 PM Brw Excel Worksheet Functions 1 November 18th 04 11:43 AM

All times are GMT +1. The time now is 02:14 AM. Copyright ©2004-2019 ExcelBanter.