(Msg. 2) Posted: Wed Oct 28, 2009 2:08 am
Post subject: Re: 1 equals 3 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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 <Il... DeleteThis @discussions.microsoft.com> 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
(Msg. 3) Posted: Wed Oct 28, 2009 6:05 am
Post subject: Re: 1 equals 3 [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Ilona.TakeThisOut@discussions.microsoft.com> wrote in message
news:5BE907A0-F604-4731-AAC7-8CB520FAC241@microsoft.com...
> 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) __________
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office