亀暲傋懼偊亁乮偩傫偩傫乯 偼偠傔偰幙栤偝偣偰偄偨偩偒傑偡丅 excel2003偱偡偑丄亀1乣12亁傑偱偺悢帤傪暲傋懼偊偡傞帪偵亂7񓉩1011丒12丒1丒2丒3丒4丒5丒6亃偺弴斣偵懼偊偨偄偺偱偡偑曽朄偼偁傝傑偡偐丠丂 ---- A1偐傜壓曽偵僨乕僞偑偁傞偲偟偰丄 B1=IF(A1>6,MOD(A1,7)+1,A1+6) 偲擖椡偟壓曽偵僐僺儁丅丅 暲傃懼偊仺嵟桪愭偝傟傞僉乕仺楍B乮徃弴丠乯 (kei) ---- 7 =MOD(7+6,13)=0 =MOD(0-6,13)=7 8 =MOD(8+6,13)=1 =MOD(1-6,13)=8 丒 丒 12 =MOD(12+6,13)=5 1 =MOD(1+6,13)=7 2 =MOD(2+6,13)=8 丒 5 =MOD(5+6,13)=11 =MOD(11-6,13)=5 6 =MOD(6+6,13)=12 =MOD(12-6,13)=6 (NB) ---- 丂偍擇恖偲傕暘偐傝傗偡偔丄偁傝偑偲偆偛偞偄傑偟偨丅偳偪傜傕挧愴偟偰帒椏嶌惉傪偟偨偄偲巚偄傑偡丅杮摉偵偁傝偑偲偆偛偞偄傑偟偨丅丂丂丂丂丂乮偩傫偩傫乯 ---- 夝寛嵪傒偺傛偆偱偡偑 >亂7񓉩1011丒12丒1丒2丒3丒4丒5丒6亃 仾丂傪僣乕儖 仺 僆僾僔儑儞 仺 儐乕僓乕愝掕儕僗僩偵搊榐偟偰 暲傋懼偊偺僆僾僔儑儞偐傜偦傟傪婎偵暲傋懼偊傟偽偄偄偲巚偄傑偡丅 乮sky乯 ---- 偁傝偑偲偆偛偞偄傑偟偨丅偙偺曽朄偩偲峴傪憹傗偝側偄偱傛偄偺偱椙偄偱偡偹丅乮偩傫偩傫乯