1 equals 3

[Ilona]

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

 

[Roger Govier]

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

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

 

[Pete_UK]

Use this in B1, assuming your numbers start in A1:

=4-A1

Copy this down as required, then hide column A.

Hope this helps.

Pete