Reverse numerical values

[stevewy]

If I had a spreadsheet with numerical values down one column, integers
between 1 and 9. I want to be able to "reverse" each number so that 1
will become 9, 2 becomes 8, 3 becomes 7, etc, down to 9 becoming 1.

It's so that I can analyse a survey where people have been asked to
give a 1 for their first choice, 2 for their second choice etc.
Sometimes they have 6 choices, sometimes 9, sometimes 5 depending on
the question. Blanks not filled in get zero. I'm allocating 9 points
to the 1st choice, 8 points to the second choice etc, then adding them
up. Maximum points is the most popular.

Is there a formula you can think of that would do the reversing
automatically? Or something in the Paste Special that would work?

Steve Wylie
United Kingdom

 

[Bob Phillips]

Steve,

Try

=ABS(10-A1)

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[C. Roenbaugh]

Here is soln.

https://oncourse.iu.edu/access/content/user/jroenbau/answer.xls

Cr

 

[Gary''s Student]

=10-your number

 

[stevewy]

Thanks very much C. Roenbaugh and others - this is just what I wanted.

Steve