Dividend (1-Year Growth)
Returns the 1-year percentage change in dividends per share.
Syntax
=DividendOneYearGrowth(Symbol)Returns
number
1-year dividend growth as decimal
Examples
=DividendOneYearGrowth("JNJ")=DividendOneYearGrowth("PG")When to Use
- Dividend growth investing
- Income portfolio analysis
- Dividend aristocrats screening
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current dividend yield | DividendYield() |
| Dividend per share | DividendPerShare() |
Common Issues & FAQ
What if company cut dividends?
Will show negative growth rate.
Related Formulas
More MarketXLS Growth formulas you can use in the same worksheet:
- EBITDA (1-Year Growth)
- EBITDA Growth 5 Year CAGR
- EBITDA Margin (1-Year Growth)
- EBITDA Margin 5 Year Average
- EPS (1-Year Growth)
- EPS Average Growth (4Q)
- EPS CAGR 3 Year
- EPS CAGR Growth (4Y)
See DividendOneYearGrowth used in a complete workbook: Dividend Data in Excel: Late May 2026 Quality, Yield, and Payout Coverage Screen
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?