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

·Q½Ð°Ý§ÚÀ³¸Ó«ç»ò°µ

·Q½Ð°Ý§ÚÀ³¸Ó«ç»ò°µ

½Ð°Ý
§Úªº¥æ³f´Á¦pªG-5<=¤µ¤Ñ¤é´Á´N¨q"HT"
§Úªº¥æ³f´Á¦pªG-10<=¤µ¤Ñ¤é´Á´N¨q"BR"
§Úªº¥æ³f´Á¦pªG-15<=¤µ¤Ñ¤é´Á´N¨q"BF"

ÁÂÁÂANGELA¤j.²×©ó¤F¸Ñ³o¨ç¼Æªº§ó§ï¤F...
¤§«e»~¸Ñ¤F..©Ò¥H¤@ª½¤ÏÀ³¤£¹L¨Ó
¦hÁ¤F..¨¯­WÅo!!!

TOP

c2=IF(A2="","",IF(A2<TODAY(),"À³¥X³f",IF((A2-TODAY())/5+1>4,"",CHOOSE((A2-TODAY())/5+1,"ht","br","bf","ÁÙ¦³15¤Ñ"))))

TOP

RE: ·Q½Ð°Ý§ÚÀ³¸Ó«ç»ò°µ(·s°ÝÃD½ÐÀ°¦£)

¤Sµo²{¤F·s°ÝÃD...½ÐÀ°¦£..«ô°U!!

½d¨Ò2.rar (2.54 KB)

TOP

®¦..¤F¸ÑÅo!!
ANGELA¤jªºÀ°¦£
¨º¦pªG§Ú«á­±·QÅã¥Üªº§ó¦h´N¥²¶·§â3§ï4©Î5¨Ì»Ý¨D¬O§a!

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2012-10-4 20:28 ½s¿è

=IF((A6-TODAY())/5+1>3,"",CHOOSE((A6-TODAY())/5+1,"ht","br","bf"))
A6=§Úªº¥æ³f´Á

TOP

        ÀR«ä¦Û¦b : ÀR§¤±`®¦¤v¹L¡B¶¢½Í²ö½×¤H«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD