Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 9th 05, 03:27 AM posted to microsoft.public.excel.worksheet.functions
qwik6
 
Posts: n/a
Default 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".
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(B 4<=200,"Y",IF(B4<=100,"Z","")))))


--
qwik6
------------------------------------------------------------------------
qwik6's Profile: http://www.excelforum.com/member.php...o&userid=29502
View this thread: http://www.excelforum.com/showthread...hreadid=492068


  #2   Report Post  
Old December 9th 05, 03:50 AM posted to microsoft.public.excel.worksheet.functions
duane
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=492068

  #3   Report Post  
Old December 9th 05, 03:54 AM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default 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","")))))

  #4   Report Post  
Old December 9th 05, 04:38 AM posted to microsoft.public.excel.worksheet.functions
qwik6
 
Posts: n/a
Default 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
View this thread: http://www.excelforum.com/showthread...hreadid=492068



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add more than 7 if nested statements. 7 is the limit. RRS from Connecticut Excel Discussion (Misc queries) 7 September 23rd 05 07:35 PM
Nested IF statements John Simons Excel Worksheet Functions 14 February 16th 05 07:17 AM
Employing constant arrays to limit nested IF statements. Richard-44 Excel Worksheet Functions 2 January 6th 05 03:19 AM
Nested If/Then Math Expert Needed Steven Excel Worksheet Functions 1 January 5th 05 10:52 PM
If/Then statements with images??? Brw Excel Worksheet Functions 1 November 18th 04 11:43 AM


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017