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)
Increment of 1000 15 10 5 1
Level Needed Level 1 Level 2 Level 3 Level 4 Level 5
1 1000
2 1025
3 1035
4 1040
5 1041
5 1042
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)
Increment of 1000 15 10 5 1
Level Needed Level 1 Level 2 Level 3 Level 4 Level 5
1 1000
2 1025
3 1035
4 1040
5 1041
5 1042