[[20040329095049]]@wŒ»‹ào”[’ xi‚‚‚“‚‚™‚j@>>BOT

[ ‰‚ß‚Ä‚Ì•û‚Ö | ˆê——(ÅVXV‡) | ‘S•¶ŒŸõ | ‰ß‹ŽƒƒO ]

@

wŒ»‹ào”[’ xi‚‚‚“‚‚™‚j

ƒGƒNƒZƒ‹‚O‚QE‚n‚r‚Í‚w‚o‚Å‚·B

 “ú•t@@@  “E—v@@@@ŽØ•û@@@@‘Ý•û@@@·ˆøŽc‚
 @@@@@ ŒJ‰z@@@@@@@@@@@@@@@@40000
 1/2@@@@Á–Õ•i@@@@@@@@@2000
 1/2@@@@Œð’Ê”ï@@@@@@@@@1500
 1/2@@@@Ú‘ÒŒðÛ”ï@@@@@@@5000@@@@31500
 1/6@@@@•’Ê—a‹à@50000@@@@@@@@@@@81500

‚̂悤‚ɁA“¯ˆê“ú•t‚̏ꍇAÚ‘ÒŒðÛ”ï‚̍s‚̂ݍ·ˆøŽc‚‚ªA•\Ž¦‚µ‚Ä—~‚µ‚¢‚Ì‚Å‚·B‚ǂ̂悤‚É‚·‚ê‚΂悢‚Ì‚Å‚µ‚傤H
‚æ‚낵‚­‚¨Šè‚¢‚µ‚Ü‚·B


 E3‚É=IF(COUNT(C3:D3),IF(A3<>A4,SUM(E$2,C$3:C3)-SUM(D$3:D3),""),"")
 ‚Æ‚µ‚āA‰º‚ɃtƒBƒ‹ƒhƒ‰ƒbƒOB‚Å‚Ç‚¤‚Å‚µ‚傤H     (LOOKUP)

 @@A@@@B@@@@@C@@@@@D@@@@E
 1@“ú•t@“E—v@@@@ŽØ•û@@@‘Ý•û@@·ˆøŽc‚
 2@@@@ŒJ‰z@@@@@@@@@@@@@@40,000
 3@ 1/2@Á–Õ•i”ï@@@@@@@2,000	
 4@ 1/2@Œð’Ê”ï@@@@@@@@1,500	
 5@ 1/2@Ú‘ÒŒðÛ”ï@@@@@@5,000@@31,500
 6@ 1/6@•’Ê—a‹à@@50,000@@@@@@ 81,500

‚·‚¢‚Ü‚¹‚ñB‚Å‚«‚Ü‚¹‚ñB
 @‚a@@@@@‚b@@@@@‚d@@@@@‚f@@@@@‚i
 “ú•t@@@  “E—v@@@@ŽØ•û@@@@‘Ý•û@@@·ˆøŽc‚
 @@@@@ ŒJ‰z@@@@@@@@@@@@@@@@40000
 1/2@@@@Á–Õ•i@@@@@@@@@2000
 1/2@@@@Œð’Ê”ï@@@@@@@@@1500
 1/2@@@@Ú‘ÒŒðÛ”ï@@@@@@@5000@@@@31500
 1/6@@@@•’Ê—a‹à@50000@@@@@@@@@@@81500
‚Å‚·B
”Ž®‚ð“ü‚ê‚Ü‚µ‚½‚çA
1/2@@@@Ú‘ÒŒðÛ”ï@@@@@@@5000@@@@31500
@@@@@@@@@@@@@@@@@@@@@@@@-5000
1/6@@@@•’Ê—a‹à@50000@@@@@@@@@@@81500@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@45000
‚É‚È‚è‚Ü‚·B‚æ‚낵‚­‚¨Šè‚¢‚µ‚Ü‚·B
i‚‚‚“‚‚™‚j

 ˆÈŠO‚Å‚·B‹àŠz—“‚ɐ”’l‚Ì“ü—Í‚ª‚È‚¢ê‡‚ɂ́A·ˆøŽc‚‚́A‹ó”’‚̂‚à‚è‚Å‚·B

 Ž„‚ÌŒfÚ‚µ‚½•\‚Ɛ”Ž®‚ð”z’u‚µ‚āA¶‚©‚ç
 ‚PDA—ñ‚É‚P—ñ‘}“üB
 ‚QDD—ñ‚É‚P—ñ‘}“üB
 ‚RDF—ñ‚É‚P—ñ‘}“üB
 ‚SDH—ñ‚É‚Q—ñ‘}“üB‚Æ‚µ‚Ä‚²——‰º‚³‚¢B
 J2‚É=IF(COUNT(E3:G3),IF(B3<>B4,SUM(J$2,E$3:E3)-SUM(G$3:G3),""),"")
 ‚ƁAŽ©‘R‚É•ÏŠ·‚³‚ê‚é‚Å‚µ‚傤H@@@@@@@@@@@@@   (LOOKUP)

 =IF(COUNT(E3:G3),IF(B3<>B4,SUM(J$2,E$3:E3)-SUM(G$3:G3),""),"")
 ‚±‚Ì‚Ü‚Ü‚Å‚àŽxá‚Í‚È‚¢‚Å‚µ‚傤‚ªA‰º‚̂悤‚ÉCOUNT()‚͈̔͂ð”ñ˜A‘±‚É
 ‚³‚ꂽ•û‚ªAS”z‚ª­‚È‚¢‚Å‚·B@@@@@@@@@@@@@@@(LOOKUP)
 =IF(COUNT(E3,G3),IF(B3<>B4,SUM(J$2,E$3:E3)-SUM(G$3:G3),""),"")@

‚ ‚肪‚Æ‚¤ŒäÀ‚¢‚Ü‚µ‚½B
‚Å‚«‚é‚悤‚É‚È‚è‚Ü‚µ‚½B
i‚‚‚“‚‚™‚j@


ƒRƒƒ“ƒg•ÔMF

[ ˆê——(ÅVXV‡) ]


YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki. Modified by kazu.