Hi I am trying to calculate percentage ownership of a company for a school project. we know the total will always equal 100 percent, but the total number of shares may vary if we issue additional shares. i set up 3 columns:

1 shareholder number of shares percentage

2 A B C

3 Joe 500,000 =B3/B6

4 Sally 500,000 =B4/B6

5 Mike 500,000 =b5/b6

6 total 1,500,000 100%