Create a column (later to be hidden) next to the data u want to change. In
this new column, put your =IF(A1=1,3,(IF(A1=3,2,(IF(A1=2,3))))). This should
give you the correct numbers. Then you can copy the column and paste
specuial (values only) it in your original column. Hide your newly created
column.

You can next up to 7 if then statements...if more than than you will need to
do VLookup or something different.
--
-Kaman
The IT dept people call before they call the real IT dept.


"catspore" wrote:

How to replace numbers in a cell eg if 1 to 3, if 3 to 2, if 2 to 3. Trying
to reverse score for questionnaire. Possible to create a formula instead of
doing manually?