Thread: Missing Cheque numbers in a bank book
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
kumar kumar is offline
external usenet poster
  
Posts: 30
Default Missing Cheque numbers in a bank book
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