0.1 increments

[Tlord]

In cell B1:B10 I have a value of 100, in cells A1:A10 I have values of 95-104. I need a formula that increases values in B2:B10 by 0.1 until they are equal the cells in A1:A10.

Thanks

Tim.

 

[Scott Huish]

Based on your description, this is what you have. But the values in B1:B5 are already greater than the values in A1:A5.
Where are you wanting to put these incrementing values?

Excel 2010
	A	B
1	95	100
2	96	100
3	97	100
4	98	100
5	99	100
6	100	100
7	101	100
8	102	100
9	103	100
10	104	100
Sheet1

 

[Tlord]

Based on your description, this is what you have. But the values in B1:B5 are already greater than the values in A1:A5.
Where are you wanting to put these incrementing values?

Excel 2010

	A	B

<colgroup><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]96[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]97[/TD]
[TD="align: right"]100
[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]98[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]101[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]102[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]103[/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]100[/TD]

</tbody>

Sheet1​

Thank you for getting back me.
Sorry for not stating, the value need to go in C1:C10

 

[shg]

For example, ...?

 

[Tlord]

I have a spread sheet with a column that shows the TIME (DWELL),and a column that shows the temperature range 117-123. I need the formula incolumn D that increase the value in B3 (100) by 0.1 until the values in B6:B13fall between values in B2:B3 (100-135)

[TABLE="width: 303, align: left"]
<tbody>[TR]
[TD="width: 40, bgcolor: transparent"]

​

[/TD]
[TD="width: 54, bgcolor: transparent"]

A​

[/TD]
[TD="width: 122, bgcolor: transparent"]

B​

[/TD]
[TD="width: 145, bgcolor: transparent"]

C​

[/TD]
[TD="width: 145, bgcolor: transparent"]

D​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

1​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122, bgcolor: transparent"]

DWELL TOLERANCE​

[/TD]
[TD="width: 145, bgcolor: transparent"]

TEMPERATURE TOLERANCE​

[/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

2​

[/TD]
[TD="width: 54, bgcolor: transparent"]

MAX​

[/TD]
[TD="width: 122, bgcolor: transparent"]

135.0​

[/TD]
[TD="width: 145, bgcolor: transparent"]

123.0​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

3​

[/TD]
[TD="width: 54, bgcolor: transparent"]

MIN​

[/TD]
[TD="width: 122, bgcolor: transparent"]

100.0​

[/TD]
[TD="width: 145, bgcolor: transparent"]

117.0​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

4​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[TD="width: 145, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

5​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122, bgcolor: transparent"]

^#TIME AT DWELL TEMP
(mins)​

[/TD]
[TD="width: 145, bgcolor: transparent"]

^#MAX CURE TEMP
(deg C)​

[/TD]
[TD="width: 145, bgcolor: transparent"]

REVISED MINIMUM CURE TEMPERATURE​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

6​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122"]

110​

[/TD]
[TD="width: 145, bgcolor: transparent"]

117.00​

[/TD]
[TD="width: 145, bgcolor: transparent"]

​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

7​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122, bgcolor: transparent"]

105​

[/TD]
[TD="width: 145, bgcolor: transparent"]

118.00​

[/TD]
[TD="width: 145, bgcolor: transparent"]

​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

8​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122"]

137​

[/TD]
[TD="width: 145, bgcolor: transparent"]

120.00​

[/TD]
[TD="width: 145, bgcolor: transparent"]

​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

9​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122"]

140​

[/TD]
[TD="width: 145, bgcolor: transparent"]

122.00​

[/TD]
[TD="width: 145, bgcolor: transparent"]

​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

10​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122, bgcolor: transparent"]

125​

[/TD]
[TD="width: 145, bgcolor: transparent"]

123.00​

[/TD]
[TD="width: 145, bgcolor: transparent"]

​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

11​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122, bgcolor: transparent"]

115​

[/TD]
[TD="width: 145, bgcolor: transparent"]

122.00​

[/TD]
[TD="width: 145, bgcolor: transparent"]

​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

12​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122, bgcolor: transparent"]

119​

[/TD]
[TD="width: 145, bgcolor: transparent"]

120.00​

[/TD]
[TD="width: 145, bgcolor: transparent"]

​

[/TD]
[/TR]
[TR]
[TD="width: 40, bgcolor: transparent"]

13​

[/TD]
[TD="width: 54, bgcolor: transparent"][/TD]
[TD="width: 122, bgcolor: transparent"]

129​

[/TD]
[TD="width: 145, bgcolor: transparent"]

119.00​

[/TD]
[TD="width: 145, bgcolor: transparent"]

​

[/TD]
[/TR]
</tbody>[/TABLE]

 

[AlanY]

what do you expect the numbers in D6, D7 etc?