kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
Hi,
I have thf ollowing table:
Column E shows the stock discount based on their evaluation. Total available funds are 5,000. In column H, I would like to build a formula to show what will be the ratio of amount from the 5,000 that should be invested based on the discount of the stock and the total available fund of 5,000. The investment ratio in column H has to equal 100%. Is there a way to do this? Appreciate the help.
I have thf ollowing table:
Normalize to 100^1.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | |||
11 | STOCK NAME | PRICE PER UNIT | DISCOUNT | AVAILABLE FUND | INVESTMENT RATIO | AMOUNT TO BE INVESTED | UNIT TO BE INVESTED | ||
12 | ALPHABET INC. (XNAS:GOOGL) | $ 101.13 | 41% | 5000 | 0 | #DIV/0! | |||
13 | AMAZON.COM, INC. (XNAS:AMZN) | $ 119.32 | 42% | 5000 | 0 | #DIV/0! | |||
14 | MICROSOFT CORPORATION (XNAS:MSFT) | $ 242.12 | 31% | 5000 | 0 | #DIV/0! | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I12:I14 | I12 | =H12*G12 |
J12:J14 | J12 | =E12/I12 |
E12:E14 | E12 | =D12.Price |
Column E shows the stock discount based on their evaluation. Total available funds are 5,000. In column H, I would like to build a formula to show what will be the ratio of amount from the 5,000 that should be invested based on the discount of the stock and the total available fund of 5,000. The investment ratio in column H has to equal 100%. Is there a way to do this? Appreciate the help.