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

·Q±N (200³] ¬°¤@­Ó¯Å¶Z)¤£ª¾¹D¡A¦¹¨ç¼Æ¸Ó¦p¦ó³B²z¡H

·Q±N (200³] ¬°¤@­Ó¯Å¶Z)¤£ª¾¹D¡A¦¹¨ç¼Æ¸Ó¦p¦ó³B²z¡H

¨D±Ï~

²Ä1  ·Q±N (200³] ¬°¤@­Ó¯Å¶Z)¤£ª¾¹D¡A¦¹¨ç¼Æ¸Ó¦p¦ó²¤Æ¡H

=IF(A1="",0,IF(A1>1000,1000,IF(A1>800,800,IF(A1>600,600,IF(A1>400,400,IF(A1>200,200,0)))))) ....³Ì¤j­È¨ì 5000
=IF(A1="",0,IF(A1<-1000,-1000,IF(A1<-800,-800,IF(A1<-600,-600,IF(A1<-400,-400,IF(A1<-200,200,0)))))....³Ì¤p­È¨ì -5000


²Ä2   ¥BA1  ¥Ñ 1250 (¬°1200ªº¯Å¶Z¡A±¼¨ì 800¡A¤´µM ¥i¥H¾A¥Î(¬°800ªº¯Å¶Z)¡A¦Ó¤W­±ªº¨ç¼ÆµLªk³B²z¡A


·P®¦
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 2# ANGELA

ÁÂÁ§A  ANGELA
¥i¥H¨Ï¥Î¤F
«D±`·PÁ±zªº¤À¨É~
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD