[ ίΔΜϋΦ | κ(ΕVXV) | SΆυ | ίO ]
@
wϊtΜ»θxiBj
A1=IF(NOT(OR(B1=1,B1=2)),"κΚ",IF(AND(OR(B1=1,B1=2),D1<C1),"","V")) Ζ θά·B
B1Ιw1xw2xβw13xw5xΘΗ C1Ιw½¬26N101ϊx©±ΜϊtΝΟνθάΉρB D1Ιϊt@α¦Ξw105ϊx@ ±ΜB1ͺw1xw2xΘOΘηA1ΝwκΚxA B1Ιw1xΰ΅Νw2xΕ ©ΒD1ͺC1Θ~Θηiαw105ϊxj wVx@ C1ζθOΘη(αw93ϊxjwx@ Ζ΅ά΅½B
Ζ±λͺD1Ι½ΰόκΘΔΰwxΖΘΑΔ΅ά’ά·B ϊtπόκΔ»θ³Ή½’ΜΕ·B A1ΙbZ[WiϊtπόΝ΅ΔΎ³’BjΖ·ιϋ@π³¦ΔΎ³’B
gp ExcelFExcel2007Agp OSFWindowsXP
A1=IF(NOT(OR(B1=1,B1=2)),"κΚ",IF(AND(OR(B1=1,B1=2),D1<C1),"","V")) ΦΟX @« @A1Z =IF(OR(B1=1,B1=2),IF(D1="","ϊtπόΝ΅ΔΎ³’",IF(D1<C1,"","V")),"κΚ")
iΌ½Ύj 2014/10/28(Ξ) 22:41
»±Ι»€όκιΜΕ΅½©B
Ό½Ύ³ρ@ θͺΖ€²΄’ά΅½B
iBj 2014/10/28(Ξ) 22:46
[ κ(ΕVXV) ]
YukiWiki 1.6.7 Copyright (C) 2000,2001 by Hiroshi Yuki.
Modified by kazu.