Thread: If Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default If Question

I am looking for a formula for ColB below that will produce this result:

7
90 TRUE
91 FALSE
92 FALSE

Would like the formula to look at the difference between A1 and A2, A2 and
A3 etc. If the difference is equal to 1, return false.

Thank you in advance.