I am trying to create a spreadsheet to record batch numbers but I would like the batch number automatically generated. So, I want to say... if I put Yes in a certain cell I get given a batch numer and that number increases by 1 every time I put Y into the next cell. I have tried
IF (E5 ="","",2350+1) but keep getting stuck.
The hope is that if you put Y in D5 a batch number is displayed in D6, then if you put Y in E5 the next batch number in the series is displayed in E6, but if nothing is put in D5 the batch number displayed in E6 is the next number in the series. I have started my batch number series at 2350.
@HorseyAmanda OK, I've entered IF formulas in both D6 and E6 that will do (I think) what you want. I've left the D5 and E5 cells blank for now, but if you enter Y into either cell you'll see the result.
The minor modification I've made--and I think you'll need something like this--is I placed your "starting number" in the upper left corner, Cell A1, and then, depending on whether you have one or two batch numbers on this first page, you'll see that cell A1 on the NEXT spreadsheet starts with a batch number already incremented by one. So the same formulas put into that sheet's D6 and E6 will continue the pattern. (I was assuming that you're going to be using this same layout on subsequent sheets....)
@mathetes Thank you very much for your help. It works very well but I was going to add more than one batch record per sheet. Each sheet will represent a week with a total of 53 sheets for the year. There is a potential of 28 batch numbers per week. So, I'm now struggling with the formula to carry the batch number to the next batch record. How do I populate L6 &/ M6 with the same rules. Again, thanks for your help, much appreciated