View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Watlock Mark Watlock is offline
external usenet poster
 
Posts: 2
Default Increment a number by multiple criteria Excel 2007

I was asked by a co-worker to create a formula to do this but have drawn a
blank. Any ideas?
The next number increases by 11 until last digit is 0 then increases by 10
then 11 again
2619
2630
2640
2651
2662
2673
2684
2695
2706