Hi

One way
If your numbers are in column A, in column B enter
=ABS(A1-4)
and copy down as required

--
Regards
Roger Govier

"Ilona" wrote in message
...
I need to know how to insert a Function into a spreadsheet to get the
following results:

1 has to be displayed as 3, 2 as 2 and 3 as 1

Is this possible. It's a bit like scrambled numbers and I guess it has to
be
an IF Function but I never did it before and need major help.

Please somebody help

__________ Information from ESET Smart Security, version of virus
signature database 4550 (20091028) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4550 (20091028) __________

The message was checked by ESET Smart Security.

http://www.eset.com