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

½Ð°Ý¦p¦ó¤À¯Å­pºâªº¤½¦¡

½Ð°Ý¦p¦ó¤À¯Å­pºâªº¤½¦¡

ªþ¥óA1¬OÅܼÆ
®Ú¾ÚA1ªº­È¡A¤À§O¥h­pºâB4¡GF4Àx¦s®æ
¤À¯Å­pºâ.zip (8.13 KB) B4¡GF4Àx¦s®æ§Ú¥ÎIF¨ç¼Æ¥hºâ¡AÁ`ı±o¦³¯ä¤Sªø¡A½Ð°Ý¦U¦ì°ª¤â¡AÁÙ¦³§ó²¼äªº¤½¦¡¶Ü¡H
julie

¤~¥Î2­Ó IF ¤£·|¯ä¤Sªø  ¤½¦¡¦³»~¦p¤U ¶W¹L¤­¦Ê¸U¤¸¦Ü¤G¤d¤­¦Ê¸U¤¸³¡¤À
À³ ¤G¤d¤­¦Ê¸U¤¸-¤­¦Ê¸U¤¸=¤G¤d¸U¤¸*6.6% «D ¤G¤d¤­¦Ê¸U¤¸*6.6%
¦]¨ä¤¤ 500¸UÄÝ7.7%  
¾l¤@¼ËÆ[©À­×§ï
=IF(AND($A$1>5000001,$A$1<25000001),($A$1-5000000)*C3,IF($A$1>25000000,20000000*C3,""))
ù

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD