Sam Wilson;459271 Wrote:
If you first case (0.13) is met then so will the next 3 cases too -
_it_won't
ignore_the_commands_because_the_first_case_was_sat isfied_.

you want:

Case Is = 0.09, Is <0.13: FINDTier = Tier(3)

etc
In Excel 2003 at least, the underlined statement above is *not true*!
As soon as one condition is satisfied the rest are ignored, whether or
not they might be true.
From the help file:
"If testexpression matches an expressionlist expression in more than
one Case clause, only the statements following the *first *match are
executed."


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=127089