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

Àx¦s®æÅã¥ÜªÅ®æ

Àx¦s®æÅã¥ÜªÅ®æ

½Ð°Ý¦U¦ì¥ý¶i¡A¤p§Ì¦³¤@­ÓÀx¦s®æÅã¥ÜºÃ°Ý¡A¤w¸Õ¤F¦h¦¸¤½¦¡¨ç¼Æ§¡µL¹F¨ì­nªº»Ý¨D¡A¸Ô²Ó»¡©ú©óªþÀɤº¡A·Ð½Ð«ü±Ð¡AÁÂÁ·P®¦¡I Àx¦s®æÅã¥Ü°ÝÃD.zip (1.81 KB)

=IF($B5="","",IF($B5>9999,$B5/2,IF(COLUMN(A1)=1,$B5,"")))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522


    ·PÁ ¥ý¶iªº«ü¾É¡A¸g´ú¸Õ¥¿²Å¦X»Ý¨D¡A¤½¦¡¤¤³Ì«á¤@­Ó IF ªº¥Îªk¨ü±Ð¤F¡AÁÂÁ¡I

TOP

¦^´_ 2# hcm19522


    ½Ð°Ý¥ý¶i¡A³o¤½¦¡§Ú¥Î¦b 2007 ¥H«áªºª©¥»¥i¥H¥¿±`¨Ï¥Î¡A¦ý§Ú¦b 2003 ª©¥»¤W¤]·|¨Ï¥Î¡A´N·|¥X²{ #NAME¡Hªº±¡ªp¡A«e¤G­Ó IF ªº±ø¥ó¨S°ÝÃD¡A³Ì«á¤@­Ó IF ¥i¯à¦b 2003 ª©¦³°ÝÃD¡A½Ð°Ý¥i¥H¥Î§Oªº¤½¦¡¨ú¥N¶Ü¡HÁÂÁ¡I

TOP

¦^´_ 4# shan0948


    ³o¤½¦¡§Ú¥Î¦b 2007 ¥H«áªºª©¥»¥i¥H¥¿±`¨Ï¥Î¡A¦ý§Ú¦b 2003 ª©¥»¤W¤]·|¨Ï¥Î¡A´N·|¥X²{ #NAME¡Hªº±¡ªp¡A«e¤G­Ó IF ªº±ø¥ó¨S°ÝÃD¡A³Ì«á¤@­Ó IF ¥i¯à¦b 2003 ª©¦³°ÝÃD¡A§Ú¥Î§Oªº¤½¦¡ ( ¦p«á¦C¤G¤½¦¡ ) ¨ú¥N«á¡A¥i¥H¹F¨ì»Ý¨D¡AÁÙ¬O«Ü·PÁ«ü¾É¡I      
   =IF($B5="","",IF($B5>9999,$B5/2,IF($B5<9999,$B5,"")))            
   =IF($B5="","",IF($C5>9999,$B5/2,IF($B5=$C5,"",)))

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD