[[20141028204709]]@w“ϊ•t‚Μ”»’θxiƒŠƒŠƒBj@ƒy[ƒW‚ΜΕŒγ‚Ι”ς‚Τ

[ ‰‚ί‚Δ‚Μ•ϋ‚Φ | ˆκ——(ΕVXV‡) | ‘S•ΆŒŸυ | ‰ί‹ŽƒƒO ]

@

w“ϊ•t‚Μ”»’θxiƒŠƒŠƒBj

 A1=IF(NOT(OR(B1=1,B1=2)),"ˆκ”Κ",IF(AND(OR(B1=1,B1=2),D1<C1),"‹Œ","V"))
 ‚Ζ‚ ‚θ‚ά‚·B

 B1‚Ɂw1xw2x‚βw13xw5x‚Θ‚Η
 C1‚Ɂw•½¬26”N10ŒŽ1“ϊx©‚±‚Μ“ϊ•t‚Ν•Ο‚ν‚θ‚ά‚Ή‚ρB
 D1‚Ι“ϊ•t@—Ⴆ‚΁w10ŒŽ5“ϊx@
 ‚±‚ΜŽžB1‚ͺw1xw2xˆΘŠO‚Θ‚ηA1‚́wˆκ”ʁxA
 B1‚Ɂw1x‚ΰ‚΅‚­‚́w2x‚Ε
 ‚©‚ΒD1‚ͺC1ˆΘ~‚Θ‚ηi—αw10ŒŽ5“ϊxj wVx@
 C1‚ζ‚θ‘O‚Θ‚η(—αw9ŒŽ3“ϊxjw‹Œx@
 ‚Ζ‚΅‚ά‚΅‚½B

 ‚Ζ‚±‚λ‚ͺD1‚Ι‰½‚ΰ“ό‚κ‚Θ‚­‚Δ‚ΰw‹Œx‚Ζ‚Θ‚Α‚Δ‚΅‚ά‚’‚ά‚·B
 “ϊ•t‚π“ό‚κ‚Δ”»’θ‚³‚Ή‚½‚’‚Μ‚Ε‚·B
 A1‚ΙƒƒbƒZ[ƒWi“ϊ•t‚π“ό—Ν‚΅‚Δ‚­‚Ύ‚³‚’Bj‚Ζ‚·‚ι•ϋ–@‚π‹³‚¦‚Δ‚­‚Ύ‚³‚’B

ƒ Žg—p ExcelFExcel2007AŽg—p OSFWindowsXP „


 „A1=IF(NOT(OR(B1=1,B1=2)),"ˆκ”Κ",IF(AND(OR(B1=1,B1=2),D1<C1),"‹Œ","V"))
   ‚֕ύX
 @«
 @A1ƒZƒ‹ =IF(OR(B1=1,B1=2),IF(D1="","“ϊ•t‚π“ό—Ν‚΅‚Δ‚­‚Ύ‚³‚’",IF(D1<C1,"‹Œ","V")),"ˆκ”Κ")

i”Ό•½‘Ύj 2014/10/28(‰Ξ) 22:41


 ‚»‚±‚Ι‚»‚€“ό‚κ‚ι‚Μ‚Ε‚΅‚½‚©B

 ”Ό•½‘Ύ‚³‚ρ@‚ ‚θ‚ͺ‚Ζ‚€‚²‚΄‚’‚ά‚΅‚½B

iƒŠƒŠƒBj 2014/10/28(‰Ξ) 22:46


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

[ ˆκ——(ΕVXV‡) ]


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