ªð¦^¦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

¦^´_ 1# 7777


=IF(A1="","",SIGN(A1)*MIN((FLOOR(ABS(A1),200)),5000))

TOP

¦^´_ 2# ANGELA

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

TOP

        ÀR«ä¦Û¦b : ¸Ü¦h¤£¦p¸Ü¤Ö¡A¸Ü¤Ö¤£¦p¸Ü¦n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD