Hi there.
I'm putting together a rough worksheet to track investments and dividend payments and would like a basic formula to work out the purchase (or sale) price of a particular stock based off number of shares purchased and total value paid. It seems like a basic thing, but I want to be able to see at a glance in the spreadsheet and potentially add a graph and average purchase price at a later point.
In the attached spreadsheet, I want cell H8 to look and see whether cell F8 has a value in it, and if it does, then to divide F8 by D8.
I.e. 1800/50 = 36
I would then do the same for cell I8 by checking cell G8 and, if there's a value, multiplying it by E8.
Am I making sense? Is this really too easy, but I'm still missing it?
Thanks in advance.
Bookmarks