ExcelChampion
Well-known Member
- Joined
- Aug 12, 2005
- Messages
- 976
The below is simple:
If I type 3 in A1 the formula returns 1. If I type 1 in A1 the formula returns 2. If I type 2 in A1 the formula returns 3.
I want the opposite. If I type 2 in A1 it returns 1. If I type 1 in A1 it returns 3. If I type 3 in A1 it retunrs 2.
Can't get my head around it. Any help is appreciated.
If I type 3 in A1 the formula returns 1. If I type 1 in A1 the formula returns 2. If I type 2 in A1 the formula returns 3.
I want the opposite. If I type 2 in A1 it returns 1. If I type 1 in A1 it returns 3. If I type 3 in A1 it retunrs 2.
Can't get my head around it. Any help is appreciated.
PPT.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 3 | |||||
2 | ||||||
3 | 1 | |||||
Sheet1 |