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

[µo°Ý] ¤£ª¾­þ¸Ì¥X°ÝÃD(C3>0,8-C3,0),D3>0,8-D3)

[µo°Ý] ¤£ª¾­þ¸Ì¥X°ÝÃD(C3>0,8-C3,0),D3>0,8-D3)

¥»©«³Ì«á¥Ñ milk609609 ©ó 2019-7-2 10:57 ½s¿è

C3Äæ¬O3/    D3Äæ¬O8/   E3Äæ¨ç¼Æ=>IF(AND(C3="",D3=""),"",IF(AND(C3>0,8-C3,0),D3>0,8-D3))=>À³¸Ó¬OÅã¥Ü5=>µ²ªGÅã¥Ü0
C4Äæ¬O0/    D4Äæ¬O8/   E4Äæ¨ç¼Æ=>IF(AND(C4="",D4=""),"",IF(AND(C4>0,8-C4,0),D4>0,8-D4))=>À³¸Ó¬OÅã¥Ü8=>µ²ªGÅã¥Ü0
C5Äæ¬O8/    D3Äæ¬O3/   E5Äæ¨ç¼Æ=>IF(AND(C5="",D5=""),"",IF(AND(C5>0,8-C5,0),D5>0,8-D5))=>Åã¥Ü5=>µ²ªG¥¿½T
C6Äæ¬O8/    D6Äæ¬O8/   E6Äæ¨ç¼Æ=>IF(AND(C6="",D6=""),"",IF(AND(C6>0,8-C6,0),D6>0,8-D6))=>Åã¥Ü0=>µ²ªG¥¿½T
C7Äæ¬O8/    D6Äæ¬O0/   E7Äæ¨ç¼Æ=>IF(AND(C7="",D7=""),"",IF(AND(C7>0,8-C7,0),D7>0,8-D7))=>Åã¥Ü8=>µ²ªG¥¿½T

§Ú¸Õ¤F¦n¤[,½Ð°Ý¨ç¼Æ­þ¸Ì¥X°ÝÃD?
½Ð¨ó§UÀ°¦£,«D±`·PÁÂ

=IF(AND(C3="",D3=""),"",8-IF(AND(C3>0,D3<8),D3,C3))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522


   ¥i¥H¤F,«D±`·PÁÂ~~~;P

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD