Excel spreadsheet

[KyaJae]

Might be a little ling winded but please bare with me.

I am almost finished with a calculation sheet for my co-workers that will help them with quoting jobs.

This is for the supply and installation of security screens. I have so far created it so that there is a total cost for the 3 different types of security screens based on sizes and type, however if we are only installing between 1 and 3 screens, we add on a charge. I have made this to only reach a limited total but just wondering how I would take off this amount if we are to install more than 3.


I hope this makes sense!

 

[t0ny84]

Here is another possible solution, it can be adjusted if you need to add in more lines e.g. if have different prices per m2 for the materials, etc. If you could upload a copy or an example of your sheet it would allow a bit more understanding of how it is setup and what the best formula might be.

=IF(B2<3,SUM(B2*C2*D2)+(93.5*B2),SUM(C2*D2))

This says if the amount of screens under 3 then add the amount of screens multiplied by $95,30 surcharge.
Breakdown
=IF(B2<3, <- If B2 is less than 3 then it needs to go to PART A of the formula, if more than 3 then it goes to PART B of the formula.

PART A - SUM(B2*C2*D2)+(93.5*B2),
Calculation of (Total Screens x Total m2 x Price Per m2) +(Total Screens x Surcharge $93.50)

PART B - SUM(B2*C2*D2))
Calculation of (Total Screens x Total m2 x Price Per m2)

 

[Michael M]

Your posts are still prestty vague.
How about soemthing like this....assuming there is no surcharge for more than 3 screens

Book1
	A	B	C	D	E
1	screen size m2	$ per m2	no of Screens	surcharge	Total
2	2.5	$30.00	2	$187.00	$262.00
Sheet1

Cell Formulas
Range	Formula
D2	D2	=IF(C2<4,C2*93.5,0)
E2	E2	=A2*B2+D2