[ ‰‚ß‚Ä‚Ì•û‚Ö | ˆê——(ÅVXV‡) | ‘S•¶ŒŸõ | ‰ß‹ŽƒƒO ]
@
w‚h‚eŠÖ”‚Ì”ðŒÝ’è‚ɂ‚¢‚Äxiƒ}ƒNƒ‚ñj
@@‚`@@‚a@@‚b@‚c@‚d
@
1@¬Œv@¬ì@0@ “c’†@5
2@Ÿ”s@¬ì@‚k@“c’†@‚v
3
ã‹L‚Ì—l‚È•\‚ª‚ ‚è‚Ü‚·B
‚b‚Q‚É‚ÍA=IF(C1>E1,"‚v",IF(C1<E1,"‚k",IF(C1=E1,"‚c","-")))
‚Æ‚¢‚¤”Ž®‚ð“ü‚ê‚Ä‚Ü‚·‚ªA¬ì“c’†0‚ÌŽži0‘Î0j‚ÍA
h‚ch‚Å‚Í‚È‚Ah-h‚ðo—Í‚µ‚½‚¢‚Ì‚Å‚·‚ªA”Ž®‚ª•ª‚©‚è‚Ü‚¹‚ñB
‚Ç‚¤‚¢‚¤Ž®‚É‚µ‚½‚ç‚æ‚¢‚Å‚µ‚傤‚©H
ƒ Žg—p ExcelFExcel2013AŽg—p OSFWindows10 „
=IF(C1>E1,"‚v",IF(C1<E1,"‚k",IF(C1=0,"-","‚c")))
‚±‚¤‚¢‚¤‚±‚ÆH iÎj 2018/10/02(‰Î) 12:48
‚±‚ñ‚ÈŠ´‚¶‚Å‚à
=IF(C1&E1="00","-",TEXT(C1-E1,"‚v;‚k;!‚c"))
C1‚ÆE1‚É•‰”‚Í“ü‚ç‚È‚¢‚Ì‚È‚ç =IF(SUM(C1,E1)=0,"-",TEXT(C1-E1,"‚v;‚k;!‚c"))
ŽQl‚Ü‚Å iÎj 2018/10/02(‰Î) 12:53@”Ž®’ljÁ13:09
[ ˆê——(ÅVXV‡) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.