- ©«¤l
- 967
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 1001
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-11-29
- ³Ì«áµn¿ý
- 2022-5-17
|
¦^´_ 1# kim0107
ÃD¥Ø¬O
<=10 =0 ¤¹¦¬
<=10 >0 ©Ú¦¬
<=100 <=1 ¤¹¦¬
<=100 >1 ©Ú¦¬
§AªºIF×¥¿
C2=IF(AND(A2<=10,B2=0),"¤¹¦¬",IF(AND(A2<=10,B2>0),"©Ú¦¬",IF(AND(A2<=100,B2<=1),"¤¹¦¬",IF(AND(A2<=100,B2>1),"©Ú¦¬",""))))
C2=IF(A2<=10,IF(B2=0,"¤¹¦¬","©Ú¦¬"),IF(A2<=100,IF(B2<=1,"¤¹¦¬","©Ú¦¬"))) |
|