by acknak » Wed Jan 23, 2008 3:12 am
I can see what you want to do, but I can't see why you're having the trouble you describe: "... when I drag the column down the only thing that shows up in the cell is the formula."
Here, try the spreadsheet file I've attached below, maybe this will help you get started.
Open the file in Calc. There's a sample you can fill in yourself in the first sheet.
Enter the formulas just as they're shown here, starting with the "=" and ending with Enter.
Click on cell D4. Enter the formula: =C4B4
You should see the result: $23.
Click on cell E4. Enter the formula =B4
You should see the result: $16
Now, click on cell E4 again and drag the fill handle over to the right to encompass cells F4 and G4. Release the mouse button.
You should see results in columns F & G now: $39 $23
If you click on cell F4 or G4, you can see that the "fill drag" has copied the formula from E4 into the other cells, and adjusted the formula so that it refers to columns C4 and D4. If you doubleclick the formula, you can see colored highlights showing what cells are referred to by that formula.
Click in cell H4. Enter the formula: =$B$2+E4.
You should see the result: $1,391
In cell E5, enter the formula: =B5+E4
Result: $27
Filldrag E5 also to the right, into F5 and G5. Results: $68 $23
Ok, that's all the basic formulas. Now all we have to do is copy them into the other cells.
Click in cell D4; filldrag down to D10.
Note that the value in cell G5 changes from $23 to $41, because there's now a value in D5.
Click in cell H4; filldrag down to H10.
Now select cells E5 to G5 (click in E5 and drag over to G5don't drag the fill handle, just drag the mouse)
With the three cells selected, filldrag down to G10.
Your results should now match the results from Excel that you attached here.
There's also a completed example on the second sheet in the attached document (see tabs at bottom of Calc window).
 Attachments

 golf.ods
 Sample spreadsheet
 (9.9 KiB) Downloaded 144 times
AOO4/LO5 • Linux • Fedora 23