1 equals 3

  • Thread starter Thread starter Ilona
  • Start date Start date
I

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
 
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 said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
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
 
Back
Top