Beginner needs help creating a spread sheet that solves an equation.

[Elcassell]

What I want to solve is the end price of a product minus a variant I think. Here is an example of what I want it to do. I have a product that is $9 an inch and the smallest you can get is 21 inches long so to start I have 9*21=$189. Now if I have a product that is 37 inches I have $9*37in=$333 and then I need to subtract the starting cost of $189 to get the variant of $144 between 21inches and 37 inches and so on up to $9*200in = $1,800 - $189 or(9*21)=$1,611.

 

[Asbestos_Jen]

I'm not sure exactly what you're looking for. Does this help?

Book1
	B	C	D
1	$/inch	min. inches	min. charge
2	$9.00	21	$189.00
3
4	inch reqd	cost of order	cost above min
5	37	$333.00	$144.00
6	38	$342.00	$153.00
7	39	$351.00	$162.00
8	40	$360.00	$171.00
9	41	$369.00	$180.00
10	42	$378.00	$189.00
11	43	$387.00	$198.00
12	44	$396.00	$207.00
13	45	$405.00	$216.00
14	46	$414.00	$225.00
15	47	$423.00	$234.00
16	48	$432.00	$243.00
17	49	$441.00	$252.00
18	50	$450.00	$261.00
19	51	$459.00	$270.00
20	52	$468.00	$279.00
21	53	$477.00	$288.00
22	54	$486.00	$297.00
23	55	$495.00	$306.00
24	56	$504.00	$315.00
25	57	$513.00	$324.00
26	58	$522.00	$333.00
27	59	$531.00	$342.00
28	60	$540.00	$351.00
29	61	$549.00	$360.00
30	62	$558.00	$369.00
31	63	$567.00	$378.00
32	64	$576.00	$387.00
33	65	$585.00	$396.00
34	66	$594.00	$405.00
35	67	$603.00	$414.00
36	68	$612.00	$423.00
37	69	$621.00	$432.00
38	70	$630.00	$441.00
39	71	$639.00	$450.00
40	72	$648.00	$459.00
41	73	$657.00	$468.00
42	74	$666.00	$477.00
43	75	$675.00	$486.00
44	76	$684.00	$495.00
45	77	$693.00	$504.00
46	78	$702.00	$513.00
47	79	$711.00	$522.00
48	80	$720.00	$531.00
49	81	$729.00	$540.00
50	82	$738.00	$549.00
51	83	$747.00	$558.00
52	84	$756.00	$567.00
53	85	$765.00	$576.00
54	86	$774.00	$585.00
55	87	$783.00	$594.00
56	88	$792.00	$603.00
57	89	$801.00	$612.00
58	90	$810.00	$621.00
59	91	$819.00	$630.00
60	92	$828.00	$639.00
61	93	$837.00	$648.00
62	94	$846.00	$657.00
63	95	$855.00	$666.00
64	96	$864.00	$675.00
65	97	$873.00	$684.00
66	98	$882.00	$693.00
67	99	$891.00	$702.00
68	100	$900.00	$711.00
69	101	$909.00	$720.00
70	102	$918.00	$729.00
71	103	$927.00	$738.00
72	104	$936.00	$747.00
73	105	$945.00	$756.00
74	106	$954.00	$765.00
75	107	$963.00	$774.00
76	108	$972.00	$783.00
77	109	$981.00	$792.00
78	110	$990.00	$801.00
79	111	$999.00	$810.00
80	112	$1,008.00	$819.00
81	113	$1,017.00	$828.00
82	114	$1,026.00	$837.00
83	115	$1,035.00	$846.00
84	116	$1,044.00	$855.00
85	117	$1,053.00	$864.00
86	118	$1,062.00	$873.00
87	119	$1,071.00	$882.00
88	120	$1,080.00	$891.00
89	121	$1,089.00	$900.00
90	122	$1,098.00	$909.00
91	123	$1,107.00	$918.00
92	124	$1,116.00	$927.00
93	125	$1,125.00	$936.00
94	126	$1,134.00	$945.00
95	127	$1,143.00	$954.00
96	128	$1,152.00	$963.00
97	129	$1,161.00	$972.00
98	130	$1,170.00	$981.00
99	131	$1,179.00	$990.00
100	132	$1,188.00	$999.00
101	133	$1,197.00	$1,008.00
102	134	$1,206.00	$1,017.00
103	135	$1,215.00	$1,026.00
104	136	$1,224.00	$1,035.00
105	137	$1,233.00	$1,044.00
106	138	$1,242.00	$1,053.00
107	139	$1,251.00	$1,062.00
108	140	$1,260.00	$1,071.00
109	141	$1,269.00	$1,080.00
110	142	$1,278.00	$1,089.00
111	143	$1,287.00	$1,098.00
112	144	$1,296.00	$1,107.00
113	145	$1,305.00	$1,116.00
114	146	$1,314.00	$1,125.00
115	147	$1,323.00	$1,134.00
116	148	$1,332.00	$1,143.00
117	149	$1,341.00	$1,152.00
118	150	$1,350.00	$1,161.00
119	151	$1,359.00	$1,170.00
120	152	$1,368.00	$1,179.00
121	153	$1,377.00	$1,188.00
122	154	$1,386.00	$1,197.00
123	155	$1,395.00	$1,206.00
124	156	$1,404.00	$1,215.00
125	157	$1,413.00	$1,224.00
126	158	$1,422.00	$1,233.00
127	159	$1,431.00	$1,242.00
128	160	$1,440.00	$1,251.00
129	161	$1,449.00	$1,260.00
130	162	$1,458.00	$1,269.00
131	163	$1,467.00	$1,278.00
132	164	$1,476.00	$1,287.00
133	165	$1,485.00	$1,296.00
134	166	$1,494.00	$1,305.00
135	167	$1,503.00	$1,314.00
136	168	$1,512.00	$1,323.00
137	169	$1,521.00	$1,332.00
138	170	$1,530.00	$1,341.00
139	171	$1,539.00	$1,350.00
140	172	$1,548.00	$1,359.00
141	173	$1,557.00	$1,368.00
142	174	$1,566.00	$1,377.00
143	175	$1,575.00	$1,386.00
144	176	$1,584.00	$1,395.00
145	177	$1,593.00	$1,404.00
146	178	$1,602.00	$1,413.00
147	179	$1,611.00	$1,422.00
148	180	$1,620.00	$1,431.00
149	181	$1,629.00	$1,440.00
150	182	$1,638.00	$1,449.00
151	183	$1,647.00	$1,458.00
152	184	$1,656.00	$1,467.00
153	185	$1,665.00	$1,476.00
154	186	$1,674.00	$1,485.00
155	187	$1,683.00	$1,494.00
156	188	$1,692.00	$1,503.00
157	189	$1,701.00	$1,512.00
158	190	$1,710.00	$1,521.00
159	191	$1,719.00	$1,530.00
160	192	$1,728.00	$1,539.00
161	193	$1,737.00	$1,548.00
162	194	$1,746.00	$1,557.00
163	195	$1,755.00	$1,566.00
164	196	$1,764.00	$1,575.00
165	197	$1,773.00	$1,584.00
166	198	$1,782.00	$1,593.00
167	199	$1,791.00	$1,602.00
168	200	$1,800.00	$1,611.00
Sheet1

Cell Formulas
Range	Formula
D2	D2	=B2*C2
C5:C168	C5	=$B$2*B5
D5:D168	D5	=C5-$D$2