|
A
|
B
|
C
|
D
|
E
|
평문 |
N |
암호문 |
|
블록규칙
|
C |
=INDIRECT(ADDRESS(MOD(ROW()-2,4)+2,5)) |
=IF(CODE(A2)<CODE("Z")-B2+1,CHAR(CODE(A2)+B2),CHAR(CODE(A2)-26+B2)) |
|
2
|
O |
=INDIRECT(ADDRESS(MOD(ROW()-2,4)+2,5)) |
=IF(CODE(A2)<CODE("Z")-B2+1,CHAR(CODE(A2)+B2),CHAR(CODE(A2)-26+B2)) |
|
5
|
N |
=INDIRECT(ADDRESS(MOD(ROW()-2,4)+2,5)) |
=IF(CODE(A2)<CODE("Z")-B2+1,CHAR(CODE(A2)+B2),CHAR(CODE(A2)-26+B2)) |
|
8
|
T |
=INDIRECT(ADDRESS(MOD(ROW()-2,4)+2,5)) |
=IF(CODE(A2)<CODE("Z")-B2+1,CHAR(CODE(A2)+B2),CHAR(CODE(A2)-26+B2)) |
|
0
|
E |
=INDIRECT(ADDRESS(MOD(ROW()-2,4)+2,5)) |
=IF(CODE(A2)<CODE("Z")-B2+1,CHAR(CODE(A2)+B2),CHAR(CODE(A2)-26+B2)) |
|
|
N |
=INDIRECT(ADDRESS(MOD(ROW()-2,4)+2,5)) |
=IF(CODE(A2)<CODE("Z")-B2+1,CHAR(CODE(A2)+B2),CHAR(CODE(A2)-26+B2)) |
|
|
T |
=INDIRECT(ADDRESS(MOD(ROW()-2,4)+2,5)) |
=IF(CODE(A2)<CODE("Z")-B2+1,CHAR(CODE(A2)+B2),CHAR(CODE(A2)-26+B2)) |
|
|
S |
=INDIRECT(ADDRESS(MOD(ROW()-2,4)+2,5)) |
=IF(CODE(A2)<CODE("Z")-B2+1,CHAR(CODE(A2)+B2),CHAR(CODE(A2)-26+B2)) |
|
|
|