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

[µo°Ý] ¨ç¼Æ_ªÅ¥Õªº¤½¦¡­ÈµLªk¥[Á`

[µo°Ý] ¨ç¼Æ_ªÅ¥Õªº¤½¦¡­ÈµLªk¥[Á`

Book1.rar (1.83 KB)
¦pÃD¡G
¯Â­È¥i¥H¥[Á`
¨Ò¦p : A4 : C4
¬°¤°»ò¤½¦¡­È¤£¯à ?

½Ð°Ý¡G­n«ç»ò­×§ïA9¤½¦¡ ?
¤~¯àÅýA9=15,B9=14,C9=21
ÁÂÁÂ !

¥»©«³Ì«á¥Ñ ML089 ©ó 2021-10-12 09:26 ½s¿è

=(0&A6)*3+(0&A7)*2+(0&A8)
=N(A6)*3+N(A7)*2+N(A8)

¨âºØ³£¥i¥H

Àx¦s®æªÅ®æ¬°¤½¦¡ªº ""¡A""*3 ·|²£¥Í¿ù»~¡A
(0&A6)*3 => (0&"") * 3 => "0" * 3 => 0¡AEXCEL·|±N¤å¦r¼Æ­ÈÂà´«¬°¼Æ­È
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089
­ì¨ÓÀx¦s®æ¥´¤F*¤§«á,´N·|Åܦ¨¤å¦r®æ¦¡
©Ç¤£±o§Ú­ì®æ½Æ»s,¿ï¾Ü©Ê¶K¤W­È,ÁÙ¬O¤£¦æ

¤@­Ó¤p°ÝÃD,¾Ç°ÝÁ٫ܦh
ÁÂÁ±zªº»¡©ú©M«ü¾É

TOP

¦^´_ 2# ML089
¥þ³¡ªÅ¥ÕªºÅã¥ÜªÅ¥Õ,¦³­È´NÅã¥Ü©M­È.rar (1.91 KB)
ª©¥D :
¦A½Ð±Ð±z :
A4=IF(SUM(A1:A3)="","",SUM(A1:A3))
¦ý§Ú­nB4=""
´N¬O·í¾ãÄæ¥þ³¡ªÅ¥Õªº¸Ü¡A©M­È´NÅã¥ÜªÅ¥Õ,
·í¾ãÄ榳¥ô1­Ó­È(¥]¬A0­È),´NÅã¥Ü©M­È¡C
ÁÂÁ±z!

TOP

¦^´_ 4# johnny1680

=IF(COUNT(A1:A3),SUM(A1:A3),"")
¥k©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 5# ML089
§Q¥Î­pºâ¼Æ­Èªº­Ó¼Æ¨Ó§P§O0©M""¡A°ª©ú!
¦h¾Ç¤@©Û
ÁÂÁ±z!

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD