Need help please

Copper Contributor

Hi, i work in a dental practice and needed help making a sequence so when i add a prescription num it automatically adds 9 onto the number and generates the next one. It should do this 10 times and then add 19 once and then start adding 9 again.

2 Replies

@Ayman1955 

You provide preciously little detail.

Let's say you enter the initial prescription number in A2.

Enter the following formula in A3:

=A2+IF(MOD(ROW(),11)=2,19,9)

Fill down as far as you want.

dsdsd