Thread: Missing Cheque numbers in a bank book
View Single Post
  #9   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
You are very welcome. I use a similar method in my own checkbook.
--
Gary''s Student - gsnu200814


"Kumar" wrote:

Thanks a lot it worked....

"Gary''s Student" wrote:

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



--
Gary''s Student - gsnu200814
Reply With QuoteReply With Quote