1 equals 3


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
 
Ad

Advertisements

R

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

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
__________ Information from ESET Smart Security, version of virus signature database 4550 (20091028) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Ad

Advertisements

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top