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

[µo°Ý] EXCEL¨ç¼Æ(IF)¨D¸Ñ (¤j©ó¤p©ó°ÝÃD)

¥»©«³Ì«á¥Ñ inhogold ©ó 2017-12-18 11:26 ½s¿è

¥i½Ð°Ý¤j¤j­Ì~
°²³]§Ú¥u¬O¤j©ó¹s¥H¤Î¤p©ó¹sªº¸Ü¡A§Ú¥ÎIF¡A¥i¬O«o¨S¦³¶Ç¦^§Ú­nªº1¸ò-1
¬O¤£¬O§Úªº¤½¦¡ÁÙ¬O»{ª¾¤W¦³»~¡A¥i½Ð½ç±Ð¶Ü??
¤j©ó¹s¤p©ó¹s.png
¸U¤V°ª¼Ó¥­¦a°_

TOP

ÁÂÁÂjoblyc017¤jªº¸Ñµª
½Ð°Ýjoblyc017¤j
«ö±z©Ò³sµ²ªººô§}¤w¸Ñ¨M§Úªº°ÝÃD¡A
§Ú¥Î±zªº¨ç¼Æ=IF(--(B2)<0,-1,1)¡A
«á¨Ó¹Á¸Õ¥Î    =IF((B2)<0,-1,1)¡A
¥L¤]¬O¥i¥H¡A¥i¥H½Ð°Ý¦h¤F--<=====¥L¬O¦³¬Æ»ò¯S§Oªº·N¸q¶Ü?
³Â·Ð±z¸Ñ´b¤F,¦A¦¸·PÁ±z!!
¸U¤V°ª¼Ó¥­¦a°_

TOP

ÁÂÁÂjoblyc017¤jªº¸Ñµª,­ì¨Ó¦p¦¹
¼g¤Jµ{¦¡«á¡A¦³­Ó·sªº°ÝÃD......
µ{¦¡§â0¦^¶Ç¬°1¡A><""¡A¸Ó¥Î¤j©ó¡Ù¤p©ó¡Ø¶Ü???

0³Q»{¬°1

¤j©ó¹s¤p©ó¹s2.png
2017-12-18 18:01
¸U¤V°ª¼Ó¥­¦a°_

TOP

·P®¦joblyc017¤j¡AÆg¹Äjoblyc017¤j
¥ÎIFªºIF¤@­Ó¤½¦¡´N·d©w¤ñ¸û²³æ«W¸¨
¦A¥ÎTEXT¹LÂo¥X¨Ó,¯u¬O·Q¯}ÀY¤]·Q¤£¥X¨Ó~
¦A¦¸·PÁÂ!!Æg!!
¸U¤V°ª¼Ó¥­¦a°_

TOP

¥»©«³Ì«á¥Ñ inhogold ©ó 2017-12-19 06:15 ½s¿è

¦^´_ 12# joblyc017

½Ð±Ðjoblyc017¤j¡A¨Ì¤½¦¡¿é¤J«á¡A§Ú¥h¥[Á`¡A·í¦^¶Ç¬°0®É¡A¤½¦¡¤£¯à¦Û°Ê¥[Á`¡C
§Ú¹Á¸Õ±N1,-1,0 Äæ¦ìÂର¼Æ­È¡A¦ý«oÁÙ¬OµLªk¥[Á`.....
·d¤£À´¨º¨à¥X°ÝÃD!!Q.Q ¨D±Ï!!¦A¦¸³Â·Ð¤F!!

µLªk¥[Á`

¤j©ó¤p©ó¹s.png
¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 15# joblyc017

ÁÂÁÂjoblyc017¤j
³o¨ç¼Æ¤w§â§Ú·d²V¤F,¹Á¸Õ²z¸Ñ¤¤,
§Ú«öµÛ¿é¤J,¶]¤£¥X¨Ó,¥i¥H·Ð½Ðjoblyc017¤j
¶Ç­ÓÀɶÜ?§Ú¬Ý¬Ý§Ú¶]±o¥X¨Ó¶Ü?
³Â·Ð¤F!!·P®¦!!   ><"
¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 17# Hsieh

ÁÂÁª©¤j~~¨ç¼ÆSIGN¡A´N¥i¤À¥X£{~~·PÁÂHsiehª©¤j~~
¤]¦A¦¸·PÁ  joblyc017¦h¦¸¨Óªº¸Ñ´b~~
·P®¦~~~
¸U¤V°ª¼Ó¥­¦a°_

TOP

        ÀR«ä¦Û¦b : ¡i°±º¢¤£«e¡A²×µL©Ò±o¡j¤H³£°g©ó´M§ä©_ÂÝ¡A¦]¦Ó°±º¢¤£«e¡FÁa¨Ï®É¶¡¦A¦h¡B¸ô¦Aªø¡A¤]¤FµL¥Î³B¡A²×µL©Ò±o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD