2025 is a special number, as various social media posts have pointed out. It can be calculated in some interesting ways like (20 + 25)2 = 2025. Naturally we had to convert these into Excel formulas.
2025 is 45 squared, in other words, a ”perfect square”. This last happened in the year1936 (442) and the next time will be the 2116 (462).
Excel uses the ^ or carat sign for exponents – ^2 squares a number, ^3 is a cube. We even included a simple LAMBDA() function for the hell of it.
Cube() is =LAMBDA(x, x ^ 3) or another way to write the repeated cube formula from the cell above.
Here’s the formulas as text, to save you retyping them.
=45^2
=(20+25)^2
=(20+25)^(20/(2<em>5)) =9^2</em>5^2
=40^2+20^2+5^2
=1^3+2^3+3^3+4^3+5^3+6^3+7^3+8^3+9^3
=Cube(1)+Cube(2)+Cube(3)+Cube(4)+Cube(5)+Cube(6)+Cube(7)+Cube(8)+Cube(9)
=(1+2+3+4+5+6+7+8+9)^2
Happy New Year!
