LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Condition Statement

Wonder if you can help me on this:

I'm writing more than 4 conditional statement in one loop:

If =Bear Then
If =Blue Then return
If =Red Then return
If <Bear Then
If =Yellow Then return
.....

The problem is that =Red condition keeps returning true even under <Bear
i.e. 'Red' keeps showing up no matter what
Why is that?




 
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
Multiple condition if statement Tel Excel Discussion (Misc queries) 4 June 25th 09 02:35 PM
IF statement...And condition Rich D Excel Discussion (Misc queries) 1 January 4th 08 03:50 PM
3 logical condition if statement Mikehughes Excel Worksheet Functions 3 July 19th 06 01:59 PM
Blanks as a condition of a statement Stuck on Blanks New Users to Excel 2 November 23rd 05 12:24 AM
Condition Statement Django Excel Discussion (Misc queries) 5 August 26th 05 06:59 PM


All times are GMT +1. The time now is 06:49 AM.

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

About Us

"It's about Microsoft Excel"