Formula help

[Mutatis Mutandis]

Hi folks,
Without going into detail I have the following problem. I use a quite complex worksheet that calculates many X Y and Z values to a .csv document that is used by another department to do whatever with.
Recently it has been decided that the base line 0 for each value will be changed and I now have to rescale several thousand values from the old to the new.
Old X 0.0 will now be 4.00, old Y 0..0 will now be -1.00 and old Z will remain at 0. The old scale increased/decreased by 0.10. However the new scale will increase/decrease by 0.02

Old X	New X	Old Y	New Y	Old Z	New Z
1.00	4.20	1	-0.8	1	0.2
0.90	4.18	0.9	-0.82	0.9	0.18
0.80	4.16	0.8	-0.84	0.8	0.16
0.70	4.14	0.7	-0.86	0.7	0.14
0.60	4.12	0.6	-0.88	0.6	0.12
0.50	4.10	0.5	-0.9	0.5	0.1
0.40	4.08	0.4	-0.92	0.4	0.08
0.30	4.06	0.3	-0.94	0.3	0.06
0.20	4.04	0.2	-0.96	0.2	0.04
0.10	4.02	0.1	-0.98	0.1	0.02
0.00	4.00	0	-1	0	0
-0.10	3.98	-0.1	-1.02	-0.1	-0.02
-0.20	3.96	-0.2	-1.04	-0.2	-0.04
-0.30	3.94	-0.3	-1.06	-0.3	-0.06
-0.40	3.92	-0.4	-1.08	-0.4	-0.08
-0.50	3.90	-0.5	-1.1	-0.5	-0.1
-0.60	3.88	-0.6	-1.12	-0.6	-0.12
-0.70	3.86	-0.7	-1.14	-0.7	-0.14
-0.80	3.84	-0.8	-1.16	-0.8	-0.16
-0.90	3.82	-0.9	-1.18	-0.9	-0.18
-1.00	3.80	-1	-1.2	-1	-0.2

What I want is a formula that can take the old values and convert them to the new? I could create a lookup table but original values run into +/- four digit numbers?

Am I asking the impossible here?

 

[RoryA]

Your formula is basically:
=new_baseline+old_value*0.2
so:
New X = 4+oldX*0.2
New Y = -1+oldY*0.2
New Z = oldZ*0.2

 

[Mutatis Mutandis]

Your formula is basically:
=new_baseline+old_value*0.2
so:
New X = 4+oldX*0.2
New Y = -1+oldY*0.2
New Z = oldZ*0.2

Dohh I'm so embarrassed!!
Thank you, sometimes you really cant see the wood for the trees!