Help with Excel

[blue-eye-boy]

I'm so stupid with excel, so here's what I want to do. I have a list of products in column a, their prices without vat in column b, Their prices with vat in column c, and prices, vat and mark-up in column d. Now I've entered all the products and their prices without vat in the columns a and b. So I can now sit for a few days and enter the formula in each cell in column c, like: =b1+(b1*14%). And so till the end. And then also in column d. But isn't their a faster way, like "telling" excel, that every value in column b, must have the price incl vat next to it in column c, and next to it in column d the price with mark-up. Something like "batch" formula. Ideas?

 

[Surv0]

Yeah, you should be able to drag that cell down or across, which ever needs to have the formula, and the formula will change according to the cells it sits in. So ya only need to program one cell, then drag across the others... works well

 

[howardb]

I usually enter the first line of formulas, then copy and paste to all the other cells - e.g.

Column A Column B Column C Column D Column E
Goods Name 99.00 =B1+14% =B1*14% =C1+10%

Assuming the ROW number is "1" , markup is 10%

Enter the formula for Column C, D, E
Select Cells C1to E1 and Copy
Highlight Cells C2 to C100 (or however far down you need to go)
Paste

Excel should automatically pick up the formula for each line...

Is this the sort of thing you're looking for?

 

[gregmcc]

enter the formula in one cell. Crtl-C it and then highlight all the cells you want to paste it in a ctrl-V it.

 

[blue-eye-boy]

enter the formula in one cell. Crtl-C it and then highlight all the cells you want to paste it in a ctrl-V it.

Worked hundreds. Thanks, and thanks to all the others too.