Number's Formula Issues

[Walkaa]

Im sure im not the first retarded novice to not understand some of numbers workings and im sure theres a simple answer, so here goes:
ive got a nice 1500 row number spreadsheet with all my products for a business now i have my suppliers cost at full then a discount amount so i have the formula =B*(1-C) which all works fine but how do i get this formula into a whole column so it just works it out for me instead of me compying and pasting into each D-cell?

Walkaa 😕

 

[exegete77]

Howdy. First you need a cell reference, but just putting B is to the entire column.

So, put the formula as B3*(1-C3)

Then, selecting that cell (with the formula in it), move the cursor to the lower right corner of the cell, and it will change to a cross-hair. Click and drag down, and it will auto fill the cells.

 

[mysterytramp]

Howdy. First you need a cell reference, but just putting B is to the entire column.

So, put the formula as B3*(1-C3)

Then, selecting that cell (with the formula in it), move the cursor to the lower right corner of the cell, and it will change to a cross-hair. Click and drag down, and it will auto fill the cells.

Actually, Numbers is pretty cool in that =B*(1-C) is perfectly valid. You can put that formula in the top cell, then use the "Insert->Fill->Fill Down" column to repeat the function. A specific reference *might* avoid some reference problems as the spreadsheet grows, but I haven't found a case where that's true.

The Excel partisans like to shovel Numbers hate, but ya gotta admit, it is a pretty cool spreadsheet.

mt