What does this sum mean?

[timsims]

=int(e12/500)*112

E12 can be any number.

I know what the sum does but I am trying to replicate it so that whenever E12 hits a multiple of 300 it adds another visit and therefore, adds another £112.

Thanks.

 

[VoG]

Try

=INT(E12/300)*112

 

[T. Valko]

=int(e12/500)*112

E12 can be any number.

I know what the sum does but I am trying to replicate it so that whenever E12 hits a multiple of 300 it adds another visit and therefore, adds another £112.

Thanks.

Replace 500 with 300?

=INT(E12/300)*112

 

[timsims]

Replace 500 with 300?

=INT(E12/300)*112

Tried it but it isn't working properly.

 

[VoG]

What is in E12 and what result are you expecting?

 

[T. Valko]

Tried it but it isn't working properly.

How about posting SEVERAL examples with the expected results.

INT rounds down to the next lowest whole number.

Are you maybe wanting to round UP to the next higher whole number?

 

[timsims]

How about posting SEVERAL examples with the expected results.

INT rounds down to the next lowest whole number.

Are you maybe wanting to round UP to the next higher whole number?

Excel Workbook
	B	C	D	E	F	G	H	I
12	Area			299	m	0
13	Nominal Stone Size				mm
14	Depth				Click here to see table
15	No of DIY Kits			0	Kits
16	Coverage (m2 per kit)			#DIV/0!	0
17	No of Tree Pits
18	Distance to Site			#N/A	miles to site
19	Total Laying Hours			#N/A	hours
20	Travelling Hours			#N/A	hours
21	Total No. of Days			#N/A	#N/A
22	Aggregate Tonnage			0.000	tonne	Approx no of resin Tubs	0
23	Resin Tonnage			0.000	tonne	No of Pallets	0
24	Delivery by			Rigid - HIAB (0-10 tonnes)		Click here to see table
25				Total Costs		Cost per m
26	Haulage to Site		10	#N/A		-	/m
27	Haulage to Warehouse		11	-		0.00	/m
28	Sub Contractor Labour			2,093.00	Sub Contractor price	7.00	/m
29	Installation Labour		12	FALSE	#N/A	-	/m	Click here to see table
30	Quality Assurance Site Visit			-	1 visit	112.00
31	Accomodation & Meals		12	#N/A		#N/A	/m
32	Wearing Course Costs		6/7	#N/A		#N/A	/m
33	Van Costs		14	FALSE		-	/m
34	Van Fuel Costs		TBC	FALSE		-	/m
35	Site Costs		18	FALSE		-	/m
36	Site Visit - Pool Cars		15	34.00		0.11	/m
37	Site Visit - Pool Car Fuel Costs		TBC	#N/A		#N/A	/m
38	Site Visit - Labour		TBC	-	1 Visit	112.00	/m
39	Warehouse - Labour		16	-		-	/m
40	Warehouse - Overheads		17	-		-	/m
41	Packing Materials		8	-		-	/m
Item 1

Excel 2007

Cell Formulas
Range	Formula
G12	=IF(E7="DIY Kits","When pricing for DIY Kits: If pricing by Area, enter area and depth as normal, and the No of its required will be shown. If pricing by the kit, enter Depth and No of Kits. The coverage will be shown",IF(E9="Tree Pits (V.O/T)","Please enter number of tree pits.",))
G26	=VLOOKUP(E14,A352:F363,3,FALSE)
G27	=VLOOKUP(E14,A352:F363,4,FALSE)
G28	=((E12>=100)*7)*(1+(E9="Tree Pits (V.O/T)"))
G29	=E29/$E$12
G31	=E31/$E$12
G32	=IF(H9="Spectrum",IF(E14=12,IF(E12>46,'Item 1'!C296,'Item 1'!C295),IF(E14=16,IF(E12>34,'Item 1'!F296,'Item 1'!F295),IF(E12>30,'Item 1'!H296,'Item 1'!H295))),VLOOKUP(E14,'Item 1'!B250:H292,I257))
G33	=E33/$E$12
G34	=E34/$E$12
G35	=E35/$E$12
G36	=E36/$E$12
G37	=E37/$E$12
G39	=VLOOKUP(E14,A352:F363,5,FALSE)
G40	=VLOOKUP(E14,A352:F363,6,FALSE)
G41	=VLOOKUP(E14,A352:F363,2,FALSE)
E15	=(1/15*E14)*E12*2
E16	=ROUND((16/E14)*0.5,1)
E18	=Distances!J9
E19	=E12/F11
E20	=('Fixed Settings'!C33*2)
E21	=ROUNDUP(IF(E19<5.9,1,E19/6)+(IF(E18>250,1,0)),0)
E22	=E12/500*E14
E23	=0.07*E22
E26	=IF(E24=0,,IF(K203=I200,"Check Price",IF(OR(E24="Network - Tail-lift Next Day",E24="Network - Tail-lift 2-3 Days",E24="Network - Tail-lift 9am",E24="Network - Tail-lift 10am",E24="Network - Tail-lift am",E24="Network - Tail-lift Timed"),VLOOKUP(K203,B203:I210,K204+1)*H23,VLOOKUP(E213,B213:C228,2)*(IF(E24=B201,G214,G213)))))
E27	=E12*G27
E28	=SUM(E12*G28)
E29	=IF(AND(E12>1,E12<100)=TRUE,(((F29-1)*190+240)*E21)*1.15)
E30	=INT(E12/500)*112
E31	=IF(AND(E12>1,E12<100,E21<>1),'Fixed Settings'!C36*F29*(E21-1))
E32	=G32*E12
E33	=IF(AND(E12>1,E12<100)=TRUE,('Fixed Settings'!C34*E21))
E34	=IF(AND(E12>1,E12<100)=TRUE,(E18*2/'Fixed Settings'!C37)*'Fixed Settings'!I37)
E35	=IF(AND(E12>1,E12<100)=TRUE,(E21*'Fixed Settings'!C35))
E37	=(E18*2/'Fixed Settings'!G37)*'Fixed Settings'!I37
E38	=INT(E12/300)*112
E39	=G39*E12
E40	=G40*E12
E41	=G41*E12
F16	=IF(E7="DIY Kits",CONCATENATE("This will cover ",E15*E16,"m2 at ",E14,"mm depth"),)
F21	=ROUNDUP(E12/E21,0)
F29	=VLOOKUP(E10,'Item 1'!A233:N238,'Item 1'!G230)
F30	=IF(E12<501,B348,IF(E12<1001,C348,IF(E12<1501,D348,IF(E12<2001,F348,IF(E12<2501,G348,IF(E12<3001,H348,IF(E12<3501,I348,IF(E12<4001,J348,IF(E12<4501,K348,IF(E12<5001,L348))))))))))
F38	=IF(E12<300,B350,IF(E12<601,C350,IF(E12<901,E350,IF(E12<1201,F350,IF(E12<1501,G350,IF(E12<1801,H350,IF(E12<2101,I350,IF(E12<2401,J350,IF(E12<2701,K350,IF(E12<3000,L350))))))))))
H22	=ROUNDUP((E23*1000)/6,0)
H23	=(ROUNDUP(E22,0)+(ROUNDUP(E23,0)))

E12 represents the area, every 300m² I want to add a visit and therefore add the £112 it costs in E38.

 

[VoG]

Try

=(1+INT(E12/300))*112