Excel formula

[marc8]

Hi all
I know this is a bit of topic just doing excel spread sheet for costing, want to enter amount of stuff in one column & use a cost per 100 as I go along is there a formula, example first row amount of fixings next unit cost per 100 last unit sum of the last 2 ( per 100 units) ?????

 

[Octopus]

Hi all looking at a sum I would like to crack

multiple rows example
f1*f2 =f3 then f3 *1.2 =f4 then f4 * 1.1 = f5
can I then copy this for each row on the sheet

yes, that should work. Try it and see.

10% mark up is a bit thin IMHO

 

[Geordie Spark]

yes, that should work. Try it and see.

10% mark up is a bit thin IMHO

Very thin!! ........ Try 25% - 30%

 

[marc8]

Hello Murdoch & Geordie spark
the 10% mark up is so I can see what it is on the job, I will adjust that value to what I want after don't forget this is not strictly 10% because already included that figure in vat this is after that cell, also job is zero rated

 

[Geordie Spark]

Hello Murdoch & Geordie spark
the 10% mark up is so I can see what it is on the job, I will adjust that value to what I want after don't forget this is not strictly 10% because already included that figure in vat this is after that cell, also job is zero rated

Ok ....... no problem,

 

[marc8]

murdoch
comes out with false can't get cell to equal before I move on it works if I do the sums for each cell individually

 

[marc8]

Geordie sparks

this gives me 2 figures in my head when I go to the office, should I get the squeeze I can move not all but I know the value of each 10% that I can move & still know what I am making

 

[marc8]

Hi all
now have formulated cells & copied over very kind friend popped in & has shown me the light great adds all totals breakdowns ect.

 

[telectrix]

i googled that. still ain't got a clue.

 

[marc8]

hi all
costed job with new excel format in a few hours & indeed it help very much, would like to move this forward with a few more bits on the excel spreadsheet, does anyone know who might be able to this sort of work (paid obviously). made a massive difference was underway with pricing the job but this took it to a new level.