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
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

<colgroup><col><col><col></colgroup><thead>
</thead><tbody>
</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)

​	A​	B​	C​	D​
1​		DWELL TOLERANCE​	TEMPERATURE TOLERANCE​
2​	MAX​	135.0​	123.0​
3​	MIN​	100.0​	117.0​
4​
5​		#TIME AT DWELL TEMP (mins)​	#MAX CURE TEMP (deg C)​	REVISED MINIMUM CURE TEMPERATURE​
6​		110​	117.00​	​
7​		105​	118.00​	​
8​		137​	120.00​	​
9​		140​	122.00​	​
10​		125​	123.00​	​
11​		115​	122.00​	​
12​		119​	120.00​	​
13​		129​	119.00​	​

<tbody> </tbody>

 

[AlanY]

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