1 
D3 =(B3^3.0)-(B2^3.0)
D4 =(B4^3.0)-(B3^3.0)
D5 =(B5^3.0)-(B4^3.0)
D6 =(B6^3.0)-(B5^3.0)
D7 =(B7^3.0)-(B6^3.0)
....

I rarely used Excel but since I don't have it installed on my computer I'm using Google Spreadsheets. Is there a way to formulate this so I don't have to keep on copying and pasting this formula?

Improve this question
3
  • can't you drag it down?
    – Raystafarian
    Commented Jan 15, 2014 at 20:56
  • @Raystafarian Doesn't dragging down move not copy?
    – puretppc
    Commented Jan 15, 2014 at 20:59
  • 1
    You have to drag the small square in bottom right corner or selected cell. Dragging from anywhere else will move the data
    – tumchaaditya
    Commented Jan 15, 2014 at 21:06

2 Answers 2

Reset to default
1

This is what you are looking for.

Formula

=ARRAYFORMULA(IF(ISBLANK(B:B)=TRUE,"",B2:B^3 - B1:B^3))

Screenshot

enter image description here

Example

I've created an example file for you: ARRAYFORMULA

Improve this answer
0
2

Highlight the first one. Click and drag the handle at the lower right corner of the highlight and it will fill the area.

Improve this answer
1
  • +1 - also a good place to bring up cell reference anchors if you need the formula to remember a certain cell in the formula and not increment it along with everything else. support.microsoft.com/kb/214143
    – panhandel
    Commented Jan 15, 2014 at 22:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.