If
 

i have two colums of increasing numbers.
the first time column b is greater than column a i want to put an arrow
in the next column.
So far whatever i do it puts the arrow every time the b is greater than
col a.
any ideas?
thanks
Jim


--
anon125
------------------------------------------------------------------------
anon125's Profile: http://www.excelforum.com/member.php...o&userid=27373
View this thread: http://www.excelforum.com/showthread...hreadid=468893

On Mon, 19 Sep 2005 12:59:16 -0500, anon125
wrote:


i have two colums of increasing numbers.
the first time column b is greater than column a i want to put an arrow
in the next column.
So far whatever i do it puts the arrow every time the b is greater than
col a.
any ideas?
thanks
Jim

One solution starting in C2

=IF(AND(B2A2,B1<=A2),"arrow","")

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________