Quote Originally Posted by Pete_UK View Post
Thanks for changing the thread title. Here's a simpler formula in B1:

=IF(A1="","",8-A1)

assuming A1 can only have the values from 1 to 7 (or be blank). Copy down as required.

Hope this helps.

Pete
Pete, I first was going to do something similar, but it does not account for the skipping of 2 in the data originally posted. If the 2 was intentional, then I think this addition to your formula will do it. It is definitely better than my solution.
=IF(A1="","",IF(A1=6,7-A1,8-A1))
Greg