- ©«¤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
|
¤£¦n·N«ä¡A»Ý¨D1©M2¦³¤@Ó³W«h§Ñ¤F»¡©ú~¸É¥R¦p¤U:
·íJ2:N2ªº¬Y¤@Ó¼ÆÈ+1©Î-1±oÈ=0®É¡A«hµø±oÈ=39
§Y
=IF(MOD(N2+1,39)=0,39,MOD(N2+1,39))
=IF(MOD(N2-1,39)=0,39,MOD(N2-1,39))
¥t¥~:·íJ2:N2ªº¬Y¤@Ó¼ÆÈ+2©Î-2±oÈ=0®É¡A«hµø±oÈ=39¡F¦p±oÈ=-1®É¡A«hµø±oÈ=38
§Y
=IF(MOD(N2+2,39)=0,39,MOD(N2+2,39))
=IF(MOD(N2-2,39)=0,39,MOD(N2-2,39))
¨ä¾lK2:N2¦P²zÃþ±À¡C
ÁÂÁÂ! |
|