Hi
sorry for not reading carefully enough (too early in the morning).
Though there's still a problem:
Assume the first condition is not met (e.g. only A20) then you say you
want the 'False' result of 'd'. BUT your second condition in this case
is also met and this would require 'e'. So what is for example your
expected result for:
A2 = 2
B2 = -1
--
Regards
Frank Kabel
Frankfurt, Germany
Peter L wrote:
Hi Frank and thanks for your answer
If it not too mutch trubble I would like to have both a worksheet
formula or a VBA solution?
In your answer you wrote that:"your first and second condition are
identical but you want different
results?" They arenīt identical, in #1 both conditions have to been
met and in #2 either of the conditionx
Regards
Peter
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!