1 equals 3
 

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

1 equals 3
 

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

1 equals 3
 

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


On Oct 28, 8:56*am, Ilona wrote:
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