Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare variables in two excel workbooks | Excel Programming | |||
How to store variables of a single cell in a column? | Excel Programming | |||
From single cell variables to a single column serie | New Users to Excel | |||
Compare two variables across two worksheets | Excel Worksheet Functions | |||
Compare two lists with two variables | Excel Worksheet Functions |