Help

[Stothek]

Hello i am new to excel really, i have typed out all my statistics coursework and i need to find Spearmens coeffiecient technique, basically i need to subtract each cell in column B and Column D, and they both go down to 100. So its basically B 1 - 100 - D 100 = (then i have to square the answer of each cell. ) I was wondering if its possible to subtract every cell in D from B so i get an answer in cell E of B - D, also is their any way of squaring each cell in one movement?! Please let me know! Help is appreciated
Thankyou

[BenjieLop]

Hello i am new to excel really, i have typed out all my statistics coursework and i need to find Spearmens coeffiecient technique, basically i need to subtract each cell in column B and Column D, and they both go down to 100. So its basically B 1 - 100 - D 100 = (then i have to square the answer of each cell. ) I was wondering if its possible to subtract every cell in D from B so i get an answer in cell E of B - D, also is their any way of squaring each cell in one movement?! Please let me know! Help is appreciated
Thankyou

Is this what you need?

In Cell E1, enter =(B1-D1)^2 and copy down until E100.