Thread: Reaching Max
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Reaching Max
In B1 enter:

=IF(OR(A1=10,A1=""),"",A1+1) and copy across.
--
Gary''s Student - gsnu200790
Reply With QuoteReply With Quote