LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Value compare problem, As Single variables Feb09

Hi Neal,

Switching the if else statement by taking negation is still present you with
the same problem. Remember, not equal will only evaluate to false if the two
items is equal. So, the else clause will likely not get execute after taking
the negation in the if expression.

Hong Quach



"Neal Zimm" wrote:

Thanks Hong,
I kinda came to my own conclusion after I posted the note.

Here's the interesting part,

While experimenting, I changed the if statement to:

if value < value then ..... ELSE .....

and it WORKED JUST FINE.

GO FIGURE.


THANKS AGAIN
--
Neal Z


 
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
Compare variables in two excel workbooks Alex Excel Programming 7 October 29th 08 11:46 PM
How to store variables of a single cell in a column? noyau Excel Programming 5 December 25th 06 01:21 PM
From single cell variables to a single column serie noyau New Users to Excel 1 December 22nd 06 06:43 AM
Compare two variables across two worksheets jlcnewyork Excel Worksheet Functions 0 February 14th 06 08:58 PM
Compare two lists with two variables John Excel Worksheet Functions 4 September 11th 05 11:18 PM


All times are GMT +1. The time now is 10:00 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"