CAGR formula in Excel

[meggenm]

I have a job at work I desperately need help with. I am calculating a Compound Annual Growth Rate for data in the Excel table attached (Copy of CAGR's)

Basically I have four years and revenue data for each year,
I have attempted to use the XIRR formula and keep getting a Number Error message in cell. I have looked at help for this function etc...

Please advise formula to use, I KNOW HOW TO MANUALLY CALCULATE with CAGR MATHEMATICAL EQUATION, but wish to learn how with a formula.



CAGR is a popular data figure, I would find it hard to believe Excel has no formula for such. Help!!! and Big Thanks!!!

Meggen