Hi
I have a column of figures, and in this column, I have the numbers 5, 6, 7,
8 & 9.
Now, only these figures are in this column, ie, cell a1 could be a 6, a7
could be a 5, etc etc ....it is a rating for an employee.
Now, what I need to do is show that if the rating shows as a 9, then a 4
must be shown in its place, if an 8, a 3 must show, if a 7, a 2 must show, if
a 6, then 2+ must show, if a 5, a 1 must show.
I have hundreds of these figures in column a. How can I change the above to
show the new ratings?
Thanks in advance,