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

[µo°Ý] ¤U¤@­Ó¯S¥ð±Àºâ

[µo°Ý] ¤U¤@­Ó¯S¥ð±Àºâ

¥»©«³Ì«á¥Ñ av8d ©ó 2017-3-10 09:27 ½s¿è

¯S¥ð±Àºâ.rar (9.07 KB)

¤U¤@­Ó¯S¥ð±Àºâ
=IF(AND(DATEDIF(C2,H2,"y")=0,DATEDIF(C2,H2,"ym")<6),
IF(AND(DATEDIF(H2,I2,"ym")=0,DATEDIF(H2,I2,"md")<>0),"ÁÙ¦³"&DATEDIF(H2,I2,"md")&"¤Ñ¡Aº¡6­Ó¤ë¡C",
IF(AND(DATEDIF(H2,I2,"ym")<>0,DATEDIF(H2,I2,"md")=0),"ÁÙ¦³"&DATEDIF(H2,I2,"ym")&"­Ó¤ë¡Aº¡6­Ó¤ë¡C",
IF(AND(DATEDIF(H2,I2,"ym")<>0,DATEDIF(H2,I2,"md")<>0),"ÁÙ¦³"&DATEDIF(H2,I2,"ym")&"­Ó¤ë¤S"&DATEDIF(H2,I2,"md")&"¤Ñ¡Aº¡6­Ó¤ë¡C",
IF(AND(DATEDIF(C2,H2,"y")=0,DATEDIF(C2,H2,"ym")>6),
IF(AND(DATEDIF(H2,J2,"ym")=0,DATEDIF(H2,J2,"md")<>0),"ÁÙ¦³"&DATEDIF(H2,J2,"md")&"¤Ñ¡Aº¡1¦~¡C",
IF(AND(DATEDIF(H2,J2,"ym")<>0,DATEDIF(H2,J2,"md")=0),"ÁÙ¦³"&DATEDIF(H2,J2,"ym")&"­Ó¤ë¡Aº¡1¦~¡C",
IF(AND(DATEDIF(H2,J2,"ym")<>0,DATEDIF(H2,J2,"md")<>0),"ÁÙ¦³"&DATEDIF(H2,J2,"ym")&"­Ó¤ë¤S"&DATEDIF(H2,J2,"md")&"¤Ñ¡Aº¡1¦~¡C"))))))))

·|¥X²{FALSE¡A¤£ª¾¹D¬O¤°»ò­ì¦]¡H½Ð¦U¦ì¦Ñ®v¨ó§UÀ°¦£¡A¸U¤À·PÁ¡I

³Æµù¡G
=IF(AND(DATEDIF(C2,H2,"y")=0,DATEDIF(C2,H2,"ym")<6), ¦pªG¤£¬O´N·|¸õ¨ì IF(AND(DATEDIF(C2,H2,"y")=0,DATEDIF(C2,H2,"ym")>6),
¦ý¬O¥L·|ª½±µÅã¥ÜFALSE

¥»©«³Ì«á¥Ñ fengetianxia ©ó 2017-3-10 10:20 ½s¿è

²Ä¤@­Ó±ø¥ó¥u¦³value if trueªºµ²ªG,¨S¦³falseªºµ²ªG,·í²Ä¤@­Ó±ø¥ó¤£º¡¨¬,´N·|ª½±µ¸õFLASE

¦pªG¤¤¶¡value if trueªºµ²ªG§PÂ_µ²§ô,´N­n¥[¤W¬A¸¹

¦b§A³o­Ó¤W´N¬O²Ä¥|¦æªº³Ì«á¤@­Ó³r¸¹«e­n¥[¤T­Ó¬A¸¹,µM«á³Ì«áªº¬A¸¹­n´î¤T­Ó

TOP

¦^´_ 2# fengetianxia


    ¾Ç²ß¤F¡A¸U¤À·PÁ¡A®tÂI­n¥Îµ{¦¡¥h¼g¤F¡C

TOP

¦^´_ 2# fengetianxia


    µ²ªG¹J¨ì¥t¤@­Ó²~ÀV¡A¥X²{"¤½¦¡¤£¯à¶W¹L8192­Ó¦r¤¸"¡AêɤF¡A§V¤O³o»ò¤[¡A§ÚÁÙ¤£·Q©ñ±ó¡A¤£ª¾¹D¦³¨S¦³¨ä¥L¿ìªk¡H

TOP

¦^´_ 4# av8d

¦pªG¥ÎExcel 2016 ¥i¨Ï¥Î IFS¨ç¼Æ¡A§Æ±æ¦³À°§U¡I

https://support.office.com/zh-tw/article/IFS-%E5%87%BD%E6%95%B8-36329a26-37b2-467c-972b-4a39bd951d45

TOP

=IF(DATEDIF(C2,H2,"y")>0,"",
TEXT(DATEDIF(H2,I2,"ym"),"0 ­Ó¤ë;;") & IF(AND(DATEDIF(H2,J2,"ym")<>0,DATEDIF(H2,J2,"md")<>0),"¤S","") & TEXT(DATEDIF(H2,I2,"md"),"0 ¤Ñ;;") & IF(DATEDIF(C2,H2,"ym")<6,"¡Aº¡6­Ó¤ë¡C","¡Aº¡1¦~¡C")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD