Squaring a column

Originally Posted by Stothek

Hello, i want to know if its possible to square a complete column. I need to square column D, so i just need to know the formula, if its possible please let me know
Thankyou

I am interpreting your problem in two ways.

One way, do you need to get the square of the sum of Column D? If so, then your formula is

=(sum(D1:D100)^2)


OR, if you want to get the square of the individual cells in Column D, then this formula

=D1^2

will give you what you want (copy down until D100 or until you meet your required range).

Regards.