Auto Fill Number With Condition

[Naresh Maloo]

In sheet one i have roll no 101 in cell A1 and 200 in cellA2. I want in sheet two auto fill roll no from column A1 to A200. with conditionthat every 10 roll no i want to skip two cell and then again continue roll no.(ForEx. 101,102,103,104,105,106,107,108,109,110,Skip two cell , 111,112, & SoOn..... How can it possible with formulas.Thanks in advance.

 

[theBardd]

Is this a Power BI question?

A1:=Sheet1!$A$2
A2:=IF(MAX($A$1:$A1)>=Sheet1!$A$3,"",IF($A1="",IF(MOD(COUNTIF($A$1:$A1,""),2)=0,MAX($A$1:$A1)+1,""),IF(MOD($A1,10)>0,$A1+1,"")))