[[20181002121913]]@w‚h‚eŠÖ”‚Ì”ðŒÝ’è‚ɂ‚¢‚Äxiƒ}ƒNƒ‚ñj@ƒy[ƒW‚ÌÅŒã‚É”ò‚Ô

[ ‰‚ß‚Ä‚Ì•û‚Ö | ˆê——(Å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

ƒRƒƒ“ƒg•ÔMF

[ ˆê——(ÅVXV‡) ]


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