| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Next number function
I have an invoice book of 100 invoices. I need something that will
show me the next number to use for the invoice number. The invoice number series (say 10001 - 10100) is set manually on the covering worksheet, but i need something to add the correct number to the invoice, being the next number in the series. Of course I can create a range of numbers to use, but how will one formula in the invoice number cell be used to allow for the next number? Esra TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function - limit to the number of IFs? | Excel Discussion (Misc queries) | |||
| random number function | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
| Using the autofill function but increment by certain number in function | Excel Worksheet Functions | |||
| Function for Rounding of Number | Excel Worksheet Functions | |||
Threaded Mode
