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

[µo°Ý] ½Ð±Ð­n³]©w¹F¦¨°Ï¶¡¹F¨ì«áµ¹¤À­n¥Î¤°»ò¨ç¼Æ

[µo°Ý] ½Ð±Ð­n³]©w¹F¦¨°Ï¶¡¹F¨ì«áµ¹¤À­n¥Î¤°»ò¨ç¼Æ

½Ð±Ð­n³]©w¤T­Ó°Ï¶¡
¦pªG­È¦b90%~93%¤§¶¡µ¹10%¡A­È¦b94%~96%¤§¶¡µ¹20%­È¦b97%~100%¤§¶¡µ¹30%
¦pªG¸¨¦b90%©M100%¤§¥~­n´î¤À¡C¨Ò¦p101%~105%­n30%-5%¡A89%~85%­n10%-5%
½Ð±Ð¦U¦ì¹F¤H¥i§_À°¦£¸Ñµª
ÁÂÁÂ

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-3 10:03 ½s¿è

¦^´_ 1# 52ee24
¶È´N1#°ÝÃD±ø¥ó
°²³]¡u­È¡v¦ì©óÀx¦s®æA1
Àx¦s®æB1¿é¤J
=IF(($A$1>=90)*($A$1<94),10,IF(($A$1>=94)*($A$1<97),20,IF(($A$1>=97)*($A$1<=100),30,IF(($A$1>=85)*($A$1<90)+($A$1>100)*($A$1<=105),-5))))
½Ð°Ñ¦Ò¡I

TOP

=LOOKUP(A1,{0,85,90,94,97,101,105},{0,5,10,20,30,25,0})

TOP

¦^´_ 2# p212


  ÁÂÁÂ
¥i¥H¥Î¤F
¤£¹L¥i¥H½Ð°Ý¤@¤U
¨ç¼Æ¤¤ªº"*"©M"+"¬O¤°»ò·N«ä¶Ü

TOP

¦^´_ 3# ANGELA


    ÁÂÁ§A
    §Ú¨S¥Î¹Llookup
    ·ÓµÛ¼g¤]¤£¹ï
   ¥i¥H¸ÑÄÀ¤@¤U¶Ü

TOP

AA.gif
2015-3-3 17:05
1

µû¤À¤H¼Æ

TOP

¦^´_ 6# ANGELA


    ÁÂÁ§A³o»ò¸Ô²Óªº¸Ñ»¡
    §Ú¦A¸Õ¸Õ¬Ý
    ¯uªºÁÂÁ§A:)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2015-3-4 09:32 ½s¿è

¦^´_ 4# 52ee24
¡u*¡v=and
¡u+¡v=or
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 8# p212


    ÁÂÁ§A
    ²M·¡©ú¥Õ¤F

TOP

¦^´_ 6# ANGELA


¥i¥H¦A½Ð±Ð¤@­Ó°ÝÃD¶Ü?
¬°¤°»ò¨ç¼Æ¸Ì­n¥Î{  }
¤£¥i¥H¥Î (  )
¥Î( )´N¿ù»~¼g¤£¥X¨Ó??
=LOOKUP(C52,{0,0.88,0.9,0.94,0.97,1,1.02},{0,0.05,0.1,0.2,0.3,0.3})

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD