SOLUTION: I need a chart that shows what 35% off is on every dollar. This is for a sale. Has to be a chart with 35% off every dollar amount up to $300.00 Thanks for your help

Algebra ->  Percentages: Solvers, Trainers, Word Problems and pie charts -> SOLUTION: I need a chart that shows what 35% off is on every dollar. This is for a sale. Has to be a chart with 35% off every dollar amount up to $300.00 Thanks for your help      Log On


   



Question 813911: I need a chart that shows what 35% off is on every dollar. This is for a sale.
Has to be a chart with 35% off every dollar amount up to $300.00 Thanks for your help

Answer by ewatrrr(24785) About Me  (Show Source):
You can put this solution on YOUR website!
 
Hi,
this is something You can easily do in an Excel Worksheet
Generate the 1st Column by putting in the 1 and then = A1 + 1
(copying that down to 300) 2nd Column is = A1 - .35*A1)
have listed thru $100 here as an Ex
1 0.65
2(A1+1) 1.3
3 1.95
4 2.6
5 3.25
6 3.9
7 4.55
8 5.2
9 5.85
10 6.5
11 7.15
12 7.8
13 8.45
14 9.1
15 9.75
16 10.4
17 11.05
18 11.7
19 12.35
20 13
21 13.65
22 14.3
23 14.95
24 15.6
25 16.25
26 16.9
27 17.55
28 18.2
29 18.85
30 19.5
31 20.15
32 20.8
33 21.45
34 22.1
35 22.75
36 23.4
37 24.05
38 24.7
39 25.35
40 26
41 26.65
42 27.3
43 27.95
44 28.6
45 29.25
46 29.9
47 30.55
48 31.2
49 31.85
50 32.5
51 33.15
52 33.8
53 34.45
54 35.1
55 35.75
56 36.4
57 37.05
58 37.7
59 38.35
60 39
61 39.65
62 40.3
63 40.95
64 41.6
65 42.25
66 42.9
67 43.55
68 44.2
69 44.85
70 45.5
71 46.15
72 46.8
73 47.45
74 48.1
75 48.75
76 49.4
77 50.05
78 50.7
79 51.35
80 52
81 52.65
82 53.3
83 53.95
84 54.6
85 55.25
86 55.9
87 56.55
88 57.2
89 57.85
90 58.5
91 59.15
92 59.8
93 60.45
94 61.1
95 61.75
96 62.4
97 63.05
98 63.7
99 64.35
100 65