Thread: 1 equals 3
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ilona Ilona is offline
external usenet poster
 
Posts: 1
Default 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