If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled range. Simply reference the first cell of the spilled range with a # ...
Discover how to calculate a payout ratio using Excel with our easy guide. Learn the formula and steps to evaluate dividends per share and earnings per share effectively.
Clay Halton was a Business Editor at Investopedia and has been working in the finance publishing field for more than five years. He also writes and edits personal finance content, with a focus on ...