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

[µo°Ý] ¦³¸ê®Æ¤~Åã¥Ü,¨S¸ê®Æ¤£­nÅã¥Ü

[µo°Ý] ¦³¸ê®Æ¤~Åã¥Ü,¨S¸ê®Æ¤£­nÅã¥Ü

¥»©«³Ì«á¥Ñ pupai ©ó 2011-1-3 16:12 ½s¿è

ªO¤j¦n
§Ú¥ÎExcel§@¤é´ÁºÞ²z
BÄ檺¤½¦¡¬O§Ú¦bºô¸ô¤W§ä¨ìªº
¦pªG§Ú·Q­n¦³¸ê®Æ¤~Åã¥Ü,¨S¸ê®Æ¤£­nÅã¥Ü
½Ð°Ý­n¦p¦ó­×§ï
ÁÂÁÂ!!

Book7.rar (6.87 KB)

¦³¸ê®Æ¤~Åã¥Ü,¨S¸ê®Æ¤£­nÅã¥Ü

B2=IF(A2="","",IF(A2-TODAY()<=180,"§Ö¹L´Á",""))  ¤U©Ô
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¤¤¾Ç¥Í
§Ú¤F¸Ñ~°ÝÃD¸Ñ¨M
ÁÂÁÂ

TOP

ÁÂÁ©p¦ý¹ê¦b¤£¤ÓÀ´­C!

TOP

¦^´_ 4# cccy


    B2=IF(A2="","",IF(A2-TODAY()<=180,"§Ö¹L´Á",""))
³o¦ê¨ç¼Æ¦³¨Ï¥Î¨â­Ó±ø¥ó¦¡,¥Î¥Õ¸Ü»¡©ú:
²Ä¤@­Ó±ø¥ó¦¡»¡©ú: B2=IF(A2="","",......)  ¥Õ¸Ü»¡©ú:°²¦pXX=YY®É,´N°µ¤@­Ó°Ê§@,§_«h´N°µ¥t¤@­Ó°Ê§@    ¨ç¼Æ¤¤ªº³r¸¹¬O¥Î¨Ó°µ¤À¬q°Ï¹jªº
¨ç¼Æ³]¦bB2³o­ÓÀx¦s®æ: °²¦p A2Àx¦s®æ µ¥©óªÅ¥Õ(""ªí¥ÜªÅ¥Õ)ªº¸Ü,´NÅã¥ÜªÅ¥Õ(""ªí¥ÜªÅ¥Õ),§_«h´N°õ¦æ²Ä¤G­Ó±ø¥ó¦¡(IF(A2-TODAY()<=180,"§Ö¹L´Á",""))
²Ä¤G­Ó±ø¥ó¦¡»¡©ú:IF(A2-TODAY()<=180,"§Ö¹L´Á","")
°²¦p A2Àx¦s®æªº­È ´î ¨t²Î¤é´Áªº­È ¤p©ó©Îµ¥©ó180®É,´NÅã¥Ü"§Ö¹L´Á",§_«hÅã¥ÜªÅ¥Õ(""ªí¥ÜªÅ¥Õ)

©Ò¥H ¨ç¼Æ·|¥ý°õ¦æ²Ä¤@­Ó±ø¥ó¦¡,§PÂ_A2Àx¦s®æ¬O§_ªÅ¥Õ,¦pªG¤£¬OªÅ¥Õ,´N­pºâA2Àx¦s®æ-¨t²Î¤é´Á,¦A§PÂ_¬O§_¤p©ó©Îµ¥©ó180 ³Ì«á±o¨ì¬O§_§Ö¹L´Áªºµ²ªG

TOP

´£¨Ñ¤@­Ó¨ç¼ÆISERROR()
­Y§Aªº¤½¦¡¬°¿ù»~©Î§ä¤£¨ì¸ê®Æ®É«h·|µLªk¦^¶Ç¼Æ­È
(#N/A.#VALUE!.#DIV/0.....)
¦¹®É¯à¥[¤WIF(ISERROR(¤½¦¡),"",¤½¦¡)
«Ü¤è«K³á

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD