Changing one value to another

[NatePie]

This may be simple but I’m not very experienced with excel, how can I type a number into a cell and have it change to a different number?

For example I want to input 360 and have it change to 68.3. If I input 361 I want that to change to 68.5, and so on for about 50 or so unique input values to each have their own unique number it changes to. Thanks

 

[Cubist]

How about this?

Book1
	A	B	C
1	360	68.3
2	361	68.5
3	362	68.7
4	363	68.9
5	364	69.1
6	365	69.3
7	366	69.5
8	367	69.7
9	368	69.9
10	369	70.1
11
Sheet3

Cell Formulas
Range	Formula
B1:B10	B1	=(A1-360)*0.2+68.3

 

[bobsan42]

This can only be done with some sort of code. You cannot just replace entered value with another.
The other way is what [B]Cubist[/B] proposed - a formula in the next column to give you the value you need. What the formula is depends on how you will determine what is the new value.