Hi Poe, Elvin and Paul,
That was a good one Poe. I think Elvin has not described the problem
properly and everyone has the solution though.

Condition 1 Elvin stated: If the value of x-y <10 then cell B3=1. FINE

Condition 2 Elvin stated: If the value of x-y<10 but 15
then cell B3 = 2. Now this is contradictory to condition 1. In con 1 <10
B3=1. Now here in CON 2 he again want <10 B3 =2.

Condition 3 Elvin stated: If value x-y<15 B3=3. Contadictory to condition 1
and part of condition 2.

I am sorry if I have misunderstood anyone here.

The alternate formula for Poe's formula=VLOOKUP(X-Y,{0,1;10,2;15,3},2) is
=IF(x-y<10,1,IF(AND(x-y=10,x-y<15),2,3)).

Poe thanks I learnt something from your formula. Elvin I request you to
consider your condition.

--
Message posted via http://www.officekb.com