View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Missing Cheque numbers in a bank book

=if(b2-b1=1,"",if(b2=b1,"cheque duplicate","cheque number " & b2-1 & " is
missing"))



--
Gary''s Student - gsnu200814