[ ‰‚ß‚Ä‚Ì•û‚Ö | ˆê——(ÅVXV‡) | ‘S•¶ŒŸõ | ‰ß‹ŽƒƒO ]
@
wIFŠÖ”@“¯‚¶ƒZƒ‹‚ÌðŒ‚ð’Zkxi‚Ì‚±j
IF(OR(B21,B2=4,B2=5,B2=9,B2=13,B2=16,B2=19,B2=21),"","Z")
‚ÌðŒŽ®‚ðAB2”Žš‚ÌðŒ‚ª‘‚¦‚é‚Ì‚ÅAB2”Žš ‚ÌŒJ‚è•Ô‚µ‚Å‚Í‚È‚A
IF(B2=HHH(1,4,5,9,13,16,19,21,...),"","Z")
‚̂悤‚ÈHHHŠÖ”‚ðŽg‚Á‚Ä’Zk‚µ‚½‚¢‚Ì‚Å‚·‚ªA‚»‚Ì•û–@‚Í‚ ‚è‚Ü‚·‚©H
‚²‘¶‚¶‚Ì•ûA‹³‚¦‚Ä‚‚¾‚³‚¢B‚¨Šè‚¢‚µ‚Ü‚·B
ƒ Žg—p ExcelFExcel2010AŽg—p OSFWindows7 „
=IF(OR(B2={1,4,5,9,13,16,19,21}),"","Z") ‚Å‚Ç‚¤‚Å‚µ‚傤‚©H ise_9j 2015/04/15(…) 11:10
‚©‚Ô‚Á‚½‚ªB
()‚Å‚Í‚È‚{}‚Å‚‚‚Á‚Ä‚‚êB ‚±‚ê‚ð”z—ñ’蔂Ƃ¢‚¤B
=IF(OR(B2={1,4,5,9,13,16,19,21}),"","Z") i‚Ë‚Þ‚Ë‚Þj 2015/04/15(…) 11:12
‚ ‚肪‚Æ‚¤‚²‚´‚¢‚Ü‚µ‚½B
‰ðŒˆ‚Å‚«‚Ü‚µ‚½B
i‚Ì‚±j 2015/04/15(…) 11:24
[ ˆê——(ÅVXV‡) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.