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

¦p¦ó®Ú¾Ú¯Å¶Zªí³]©wª÷ÃB¹ï·Ó

¦p¦ó®Ú¾Ú¯Å¶Zªí³]©wª÷ÃB¹ï·Ó

½Ð°Ý¦p¦ó®Ú¾ÚAÄæ³]©wBÄæ¹ï·ÓDÄæ¯Å¶Zªí

¬¡­¶Ã¯20.zip (8.86 KB)

joyce

¦^´_ 1# leiru

¤½¦¡§ï¦¨³o¼Ë
  1. =IF(A2<=0.07,"7%¥H¤U",IF(AND(A2>0.07,A2<0.2),"8%-19%","20%¥H¤W"))
½Æ»s¥N½X
½Ð°Ñ¦ÒCÄæ¦ì
¬¡­¶Ã¯20_°Ñ¦Ò.zip (9.86 KB)
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

¦^´_ 2# li_hsien


    ÁÂÁ±z
joyce

TOP

¦^´_ 1# leiru

=LOOKUP(A2,{0,0.07,0.2},$D$2:$D$4)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh
ÁÂÁ±z
joyce

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD