ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ³]©w®æ¦¡¤Æ±ø¥ó

[µo°Ý] ³]©w®æ¦¡¤Æ±ø¥ó

¦U¦ì¤jExcel¥ý¶i¦n,¤p§Ì³Ìªñ¦b¼g¤@­Ó±ø¥ó¦¡¤@ª½·Q¤£¥X¨Ó,¤]¥Î·j¯Áª¦¤å,¦ý§ä¤£¨ì§Ú­nªº¸Ñµª,¦]¦¹§Ô¤£¦í¤W¨Ó¨D±Ï

°ÝÃD¬O³o­Ó¼Ë¤l,§Ú¦³¤­­ÓÀx¦s®æ¤À§O¦U¦³¼Æ­È,¥þ³¡±ø¥ó¦¨¥ß§Ú¥i¥H¥Î=if(and($a$1>50,$b$1>15,.....)=true,1,0)¼g¥X
       
¦ý°ÝÃD¨Ó¤F,¦pªG§Ú·Q­n¤­­ÓÀx¦s®æ¤¤¥u¦³­n¥|­Ó±ø¥ó¦¨¥ß®É§Y¥H1Åã¥ÜÀ³¸Ó­n«ç»ò¼g©O?
ÁÂÁÂ

§Úªº°µªk¦p¤U¡A½Ð°Ñ¦Ò
=IF(((A1>40)*1+(B1>1000)*1+(C1>20)*1+(D1>900)*1+(E1>222)*1)>=4,1,0)
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

¦^´_ 2# huijuang
«Ü¦nªº¤èªk, ¦¬¤U, ÁÂÁÂ!!
¤]¥i²¤Æ¬°(¦]¬°¦U­Ó±ø¥óªºÅv­È¤@¼Ë)¡G
=IF(((A2>40)+(B2>15)+(C2>20%)+(D2>5%)+(E2<2))>=4,1,0)

TOP

¦^´_ 3# yen956

ÁÂÁ¤G¦ì¥ý¶iªº¦^µª,¤w§¹¥þ¸Ñ¨M§Úªº°ÝÃD¤F,°w¹ï¤W­z²[¼Æ¼gªk,¥i§_¸ÑÄÀ¤@¤U

1.=IF(((A2>40)*1+(B2>1000)*1+(C2>20)*1+(D2>900)*1+(E2>222)*1)>=4,1,0)
(A2>40)*1(©M±µ¤U¨Óªº¥|­Ó§PŪ¦¡¤@¼Ëª¬ªp),¬O§_¦]¬°A1¤j©ó40,TRUE­È¬°1,©Ò¥H­¼¥H1¤~·|¦¨¥ß?FALSE­È«h¬°0«h,¤£¦¨¥ß

2.=IF(((A2>40)+(B2>15)+(C2>20%)+(D2>5%)+(E2<2))>=4,1,0)
¦P²z,¦]¬°±ø¥ó¦¨¥ß,©Ò¥H(A2>40)¥ÎIF±a¥X¥²¬°TURE­È1,©Ò¥H¥i¥H¤£¥Î­¼¥H1¤F

3.=IF(((A2>40)+(B2>15)+(C2>20%)+(D2>5%)+(E2<2))>=4,1,0)
¥ÑIF±a¥X¤§§PŪ¤¤ªº²Ó¶µ(A2>40)....,§¹¾ã¼gªk¬O§_¬°(A2>40=TRUE,1,0),¤S©ÎªÌ¥¦¬Ù²¤¤F¤°»ò?

ÁÂÁÂ

TOP

§Ú¬O§â(A1>40)¡A·í¦¨if(A1>40,true,false)¨Ó¬Ý
¨º¥i¥H²¤Æ¬°(A1>40)
¦]¬°(A1>40)¦pªG¦¨¥ßªº¸Ü¡A·|Åã¥ÜTrue
©Ò¥H§Ú²ßºD¤W·|°µ¦¨(A1>40)*1¡A³o¼Ë´N·|¥i¹Bºâ¤F
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

¦^´_ 5# huijuang

©Ò¥Hif(A1>40,true,false)¸Ìªºtrue¦Û°Ê§PŪ¬°1,false«h¬°0,true¦¨¥ß«á¬°1,false«h¬°2,¹ï¶Ü?

TOP

¦^´_ 6# norafang

«Øij§A¥´¶}excel¸Õ¤@¤U
(¢Ï)¦pªGA1=50 ¡A¨º=(A1>40)·|Åã¥ÜTRUE
( B )¦pªGA1=20 ¡A¨º=(A1>40)·|Åã¥ÜFALSE
·í(A1>40)«á­±¦³¹Bºâ®É¡ATRUE·|·í¦¨1¡AFALSE·|·í¦¨0
¤]´N¬O»¡=(A1>40)*100¡A
¦pªG¬O(A)®É¡A±o¨ìªºµª®×·|µ¥©ó100
¦pªG¬O(B)®É¡A±o¨ìªºµª®×·|µ¥©ó0
°Ê©À¦¨¦]¿n¦]¦¨ªG by huijuang

TOP

¦^´_ 7# huijuang
´ú¸Õµ²ªGµL»~,·PÁ¤j¤jªº¸Ñµª

TOP

¦^´_ 2# huijuang ¤Î¦^´_ 3# yen956
¦pªG¤£¬O¨â¦ìªº«ü¾É¡A®£©È§Ú·|·Q±o½ÆÂø¤S²Âªº¤èªk¨Ò¦p¨Ï¥ÎCountIF¡A·PÁ¡I
«Ü©êºp¡A§Ú¬O¤p¾Ç¥Í¡A¤£¯à¤U¸üÀɮסA¬O­Ó¤p§¾«Ä¡I

TOP

¤j®a³£«Ü¥Î¤ß¡A·PÁ¦^µª

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD