Excel 2013: Need a formula to convert a score between 1-4 to a 1-7 scale with two decimals?

[Hotspur76]

Hi all,

My organisation currently use a 1-4 scale to score our grounds maintenance contractor's workmanship.

However, our contractor use 1-7.

I need a formula that will convert one to another with 1=1 and 4=7. I need the results to show down to 2 decimals i.e.:

1.00 = 1.00
1.50 = 2.00
2.00 = 3.00
2.50 = 4.00
3.00 = 5.00
3.50 = 6.00
4.00 = 7.00

If I just had to report in whole numbers and halves (even quarters) this would be fine, but I need to report down to the nearest second decimal (10th) i.e.: 1.37 = ?.??

Any ideas?

Thanks, Graeme.

 

[wideboydixon]

Excel 2016 (Windows) 32 bit
	A	B	C	D	E
1	Our score	Contractor Score		Contractor Score	Our Score
2	1	1		1	1
3	2	3		2	1.5
4	3	5		3	2
5	4	7		4	2.5
6				5	3
7				6	3.5
8				7	4
Sheet1

Cell Formulas
Range	Formula
B2	=(A2-1)*2+1
E2	=(D2-1)/2+1

WBD

 

[Hotspur76]

Thank you so much, works perfectly and so simple now I look at it!!!

Thanks again