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

[µo°Ý] Excel ³]©w®æ¦¡¤Æ±ø¥ó

[µo°Ý] Excel ³]©w®æ¦¡¤Æ±ø¥ó

Dear all,
ºÝ¤È¨Î¸`´r§Ö¡I
·Q»P¦U¦ì½Ð±Ð¤@­Ó°ÝÃD
1.§Ú¦bAÄæ¿é¤J¤F³\¦h¼Æ¾Ú¡C
2.§Ú§Æ±æAÄ椤¡A¥u­n¬O¾ã¼Æ©Î¬O¤p¼ÆÂI¦³¥X²{5ªº¼Æ¾Ú(¦p0.5¡B1¡B1.5¡B2¡B2.5¡B3¡B3.5............)¡A¸ÓÄæ¦ì¬O¥¿±`ªº¡A¦ý¥u­n¤£²Å¦X³o±ø¥ó«h¦Û°Ê¥X²{¶À©³

¸Ó¦p¦ó³]©w©O¡H

Thank you.

Noname.jpg
2021-6-14 16:52
Just do it.

=MOD(A1,0.5)>0
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522

±z¦n¡IÁÂÁ±zªº¼ö¤ß¦^ÂÐ
¦¹¤½¦¡¤U¤F¤§«áªºµe­±(µLªk§e²{§Ú·Q­nªºª¬ªp)



   
Noname.jpg
2021-6-14 20:51
Just do it.

TOP

¦^´_ 2# hcm19522
©êºp¡A§Úª¾¹D­þ¸Ì§Ë¿ù¤F
­ì¨Ó¬O­n©ñ¦b"¨Ï¥Î¤½¦¡¨Ó¨M©w­n®æ¦¡¤Æ¨º¨ÇÀx¦s®æ"
·P®¦·P®¦
Just do it.

TOP

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