After much playing with the automatic calculator, i thought i would take a look and see if i could see how it works.
To resolve the following 2 errors:-
(1). #DIV/O! error for Historical P/E
Simply enter the 5 Year PE High in G45 and the 5 Year Low in G46
(Just go to a financial website, like
Free stock prices, quotes, stock charts, market news and streaming real-time stock quotes. - click on Financials - enter ticker symbol - scroll down to see the 5 Year PE and Low figures.
The spreadsheet with work out the Historical P/E
(2) Blank Equity Growth Rate
Go down to cell B15 and overtype the number already in there, and repeat in all cells to k15. ie, if the cell says '$5.68', then just overtype and type in '5.68' (dont put in $ symbol).
It works for me!! This obviously is a workaround and not a fix. I can only imagine that Excel doesnt treat those cells as numbers, but as text? Eitherway, i get to see the Growth rates i need to see.
Hope it helps
