Gap check formula?

[LSSR]

Iam using Excel 2003. I have 2 col of a couple thousand rows and need to
determine where a gap in numbers exist between the rows Example:
a b
1 1 5
2 6 15
3 19 25

I recall using something similiar to =if(b1+1=a2 "no gap" "gap") but cannot
get it to work. Suggestions? Thank you

 

[Max]

Perhaps you meant this
In C1, copied down: =IF(B1+1=A2,"no gap","gap")

 

[LSSR]

Thank you for the reply. I tried it but it does not detect the gaps. Any
other formula would be welcomed.

 

[JLatham]

Max has identified the probable problem (lack of commas in your formula).
I'm just wondering if this variation might make things more visible since
you'd only see where gaps are and not be distracted by many "no gap" entries:
=IF(B1+1=A2,"","gap")

 

[LSSR]

A very useful suggestion; however, still cant ID where the gaps are.

 

[Max]

For the sample data that you posted, indicate the expected results in col C
,
and the "wrong" results you got when you used Jerry's formula

 

[LSSR]

Got it to work. thank you both

Perhaps you meant this
In C1, copied down: =IF(B1+1=A2,"no gap","gap")

 

[Max]

good to hear that. admit i'm bemused what happened over there the first time
round