Forum Discussion
Formula
I am using a spread sheet program to keep track of my stock. First col is the ticker. Second col is the number of shares I own. Third col is the dividend that the stock pays per share. The fourth co...
Greetings!
Sir,
Manual solution proposed
Formula holds in Excel Mobile App,
Even when I delete Div/Share and enter new Div/Share,
Can use "Camera tool" to capture previous values,otherwise VBA
Col A. Col B. Col C. Col D
Share. No. DPSh. Total
Msft. 2. 7. 14
⬆️ Formula
Ticker from stocks =B3*C3
Thanks,