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

[µo°Ý] ¦p¦ó¨D±o¤º¤å±ø¥óªº¾÷²v­È

[µo°Ý] ¦p¦ó¨D±o¤º¤å±ø¥óªº¾÷²v­È

¥»©«³Ì«á¥Ñ lichang ©ó 2013-3-20 23:02 ½s¿è

TEST1.rar (1.5 KB) ¦U¦ì¤j¤j¦n¡G
      ¤p§Ì§Ú¦³­Ó´Æ¤â°ÝÃD·Q½Ð¦U¦ì¤j¤j¸Ñ¨M¤@¤U
°²¦p§Ú¦³¦@¥|­Ó¤À­¶¡G
²Ä¤@¤À­¶¡GA1 = 32
²Ä¤G¤À­¶¡GA1 = 50
²Ä¤T¤À­¶¡GA1 = -15

§Ú§Æ±æ¯à¦Û°Ê§PÂ_¨C­Ó¤À­¶ªºA1¼Æ­È¡A¦pªG¤j©ó0¡A´NÀ°§Ú­pºâ¤@ÂI¡A­Y¤p©ó0¡A´Nµ¥©ó0
©Ò¥H§Ú§Æ±æ¦b²Ä¥|­Ó¤À­¶ªºA1¯à¦Û°Ê¨Dªº (1+1+0)/3=66%ªºµ²ªG

¥»©«³Ì«á¥Ñ p212 ©ó 2013-3-21 11:57 ½s¿è

¦^´_ 1# lichang
½Ð°Ñ¦Ò
¦b¡u¨D¥­§¡¡v¤u§@ªí¤§Àx¦s®æ¼g¤½¦¡
=ROUNDDOWN(100*(IF('304'!A1>0,1,0)+IF('306'!A1>0,1,0)+IF('307'!A1>0,1,0))/3,0)
µù¡G¨Ì½d¨Ò(66%)¡Aµª®×¥HµL±ø¥ó¥|¬B¤­¤J­pºâ¡A¬G±Ä¥ÎROUNDDOWN¡C

TOP

=ROUNDDOWN((('304'!A1>0)+('306'!A1>0)+('307'!A1>0))/3,2)
Àx¦s®æ®æ¦¡³]¬°¦Ê¤À¤ñ

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-3-22 10:31 ½s¿è

¦^´_ 3# ANGELA
±q¥¼ª`·N¨ì·f°t¹Bºâ«áÅÞ¿è­ÈTRUE¥iÂà´«¬°¼Æ¦r1¡AFALSE¥iÂà´«¬°¼Æ¦r0¡C ÁÂÁ«ü¾É¡I

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD