i , everybody ,
i am trying to use excel to create a chart of account (COA). the formula should sub account form the first level of the COA e. g. 1000, so for level*
depend of the level i want to sub account , as show below (i also attached my sheet that i am trying to achieve my goal)
20 10 5 1
Cur Lev Icrment Leve Needed Level - 1 Level - 2 Level - 3 Level - 4 Level - 5
1000 100 1 1000
1000 20 2 1000 1020
1000 10 3 1000 1010
1000 5 4 1000 1015
1000 1 5 1000 1016
1000 1 5 1000 1017
1000 1 5 1000 1018
1000 1 5 1000 1019
1000 1 5 1000 1020
2000 100 1 2000
2000 20 2 2000 2020
2000 10 3 2000 2010
2000 1 5 2000 2011
2000 1 5 2000 2012
2000 1 5 2000 2013
3000 100 1 3000
3000 20 2 3000 3020
3000 10 3 3000 3010
3000 5 4 3000 3015
3000 1 5 3000 3016
Bookmarks