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) ?????

 

[tazz]

can you explain, more do you want to multiply by quantity per 100....so 1=100, 2=200 etc.?

 

[marc8]

Hi tazz
other way have price per 100, but in some sections not using 100 but would like that part of cost on a sum so it puts it in. Suppose I could divide into 1 then do a multiplicatiion per row

 

[tazz]

Two ways to do this..... price per unit (ie divide by 100) or in quantity enter 1 for 100, 0.5 for 50, 0.25 for 25 etc.

 

[marc8]

Hi tazz
just trying out using excel for bill of qauntitys

 

[Octopus]

Don't forget to make your calculation include VAT and mark up!

 

[marc8]

Hi Murdoch
that may be a little out of my league but had thought of that I will add columns then add the vat & profit

 

[Schneker]

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) ?????

Hi mate pick a column/row where you want answer shown (eg D5)

Type in =((xx/100)*yy)

Where xx is the column/row cost per 100 is shown (eg C5) and yy is the column/row where quantity used is shown (eg B5)
This'll work as long as I've explained it correctly.

Cheers.

 

[tazz]

Which is divide by 100...!!!!

 

[Schneker]

Hi Murdoch
that may be a little out of my league but had thought of that I will add columns then add the vat & profit

Same idea mate,

In the the column/row you want to show a price plus VAT/ mark up etc type

=zz*?

wher zz is the column/row you are wanting to mark up add to and ? is the percentage you want to add.

Hope this makes sense!

Cheers