Ron Coderre wrote:
A couple alternatives...

If there will only be positive integer values in A1
Try this:
B1: =(A1<=4)*(6.5-A1)+0.5

Otherwise, perhaps something like this:
B1: =SUM(COUNTIF(A1,{1,2,3,4})*{5.5,4.5,3.5,2.5})+0.5

Does that help?

It certainly does, using the first formula.

Thanks.