Odell Beckham
New Member
- Joined
- Dec 17, 2020
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hi all,
I’m new to this forum but seeking your advice on how I can put a goal seek into a formula as I have to do this for multiple occasions within the same sheet.
Example is that I have my total shares and the shares of a specific shareholder.
A1 (total shares) = sum(A1:A4) = 100
A2 (shareholder 1) = 10
A3 (shareholder 2) = 20
A4 (shareholder 3) = 70
I’m looking to find a formula that will increase the shares shareholder 1 needs to hold so that the shareholder has e.g. 20% of the total shares and shareholder 2 has e.g. 30% of the total shares while shareholder 3 remains with the same amount of shares. Therefore, the total amount of shares needs to be increased by adding additional shares so that shareholder 1 & 2 own the respective shareholding.
Could you kindly help me with this problem?
Thanks
I’m new to this forum but seeking your advice on how I can put a goal seek into a formula as I have to do this for multiple occasions within the same sheet.
Example is that I have my total shares and the shares of a specific shareholder.
A1 (total shares) = sum(A1:A4) = 100
A2 (shareholder 1) = 10
A3 (shareholder 2) = 20
A4 (shareholder 3) = 70
I’m looking to find a formula that will increase the shares shareholder 1 needs to hold so that the shareholder has e.g. 20% of the total shares and shareholder 2 has e.g. 30% of the total shares while shareholder 3 remains with the same amount of shares. Therefore, the total amount of shares needs to be increased by adding additional shares so that shareholder 1 & 2 own the respective shareholding.
Could you kindly help me with this problem?
Thanks