- ©«¤l
- 323
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 407
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2017-10-22
- ³Ì«áµn¿ý
- 2022-1-18
|
¦^´_ 4# hcm19522
h¤j:·s¬K§Ö¼Ö!
·PÁ±zªº¨ç¼Æ¸Ñ^^
½Ð°Ý:
¤è¦¡¤GC1:C28=IF(ROW(A1)>27,"","A"&MID(">=<",INT(ROW(A9)/9),1)&"B,A"&MID(">=<",MOD(INT(ROW(A3)/3)-1,3)+1,1)&"C,B"&MID(">=<",MOD(ROW(A1)-1,3)+1,1)&"C")
A,B,C"¤TªÌ¤§¶¡ªº>"©Î"="©Î"<"¦³½Ä¬ðªº(§Y¤£¯à¦¨¥ß)²Õ¦X¡A¤£¦C¥X®É~
EX:
B4ªºA>B,A=C,B>C
B5ªºA>B,A=C,B=C
B7ªºA>B,A<C,B>C
B8ªºA>B,A<C,B=C
:
:
¤½¦¡n¦p¦ó×¥¿?
³Ò¾r¦A½ç¥¿!
ÁÂÁ±z! |
|