ÔõôÔÚEXCELÖиıäÈÕÆÚ¸ñʽ

ÒѾٱ¨ »Ø´ð
ÔõôÔÚEXCELÖиıäÈÕÆÚ¸ñʽ
ÎÊÔÚÏß¿Í·þ
ɨÂëÎÊÔÚÏß¿Í·þ
  • »Ø´ðÊý

    6

  • ä¯ÀÀÊý

    10,113

6¸ö»Ø´ð ĬÈÏÅÅÐò
  • ĬÈÏÅÅÐò
  • °´Ê±¼äÅÅÐò

ÒѲÉÄÉ
1¡¢Ñ¡¶¨É趨ÈÕÆÚ¸ñʽµÄµ¥Ôª¸ñÇøÓò£»

2¡¢µ¥»÷¡°¸ñʽ¡±¡ú¡°µ¥Ôª¸ñ¡±²Ëµ¥ÃüÁ

3¡¢µ÷³ö¡°µ¥Ôª¸ñ¸ñʽ¡±¶Ô»°¿ò£¬µ¥»÷¡°Êý×Ö¡±Ñ¡Ï£»ÔÚ¡°·ÖÀࡱÁбíÖÐÑ¡Ôñ¡°ÈÕÆÚ¡±Ñ¡Ï

4¡¢ÔÚ¡°ÀàÐÍ¡±ÁбíÖÐÑ¡ÔñËùÐèÒªµÄÄê¡¢Ô¡¢ÈÕ¸ñʽ¼´¿É¡£

5¡¢µã»÷È·¶¨ºó¿´Ð§¹û¡£
È¡Ïû ÆÀÂÛ
¼ÓÈ빫ʽ=now() ¾ÍºÃÁË
È¡Ïû ÆÀÂÛ
=RIGHT(A1,4)&-&LEFT(A1,2)&-&MID(A1,4,2)
È¡Ïû ÆÀÂÛ
Ö±½ÓÌí¼Ó¸½¼þ¾Í¿ÉÒÔ½â¾öÁË
È¡Ïû ÆÀÂÛ
±ÈÈ磿
È¡Ïû ÆÀÂÛ
=DATE(2009,ROW(A1),1)
È¡Ïû ÆÀÂÛ
ZOLÎÊ´ð > ÔõôÔÚEXCELÖиıäÈÕÆÚ¸ñʽ

¾Ù±¨

¸ÐлÄúΪÉçÇøµÄºÍг¹±Ï×Á¦Á¿ÇëÑ¡Ôñ¾Ù±¨ÀàÐÍ

¾Ù±¨³É¹¦

¾­¹ýºËʵºó½«»á×ö³ö´¦Àí
¸ÐлÄúΪÉçÇøºÍг×ö³ö¹±Ï×

ɨÂë²ÎÓëÐÂÆ·0ÔªÊÔÓÃ
ɹµ¥¡¢¶¥Â¥ºÀÀñµÈÄãÄÃ

ɨһɨ£¬¹Ø×¢ÎÒÃÇ
Ìáʾ

È·¶¨ÒªÈ¡Ïû´Ë´Î±¨Ãû£¬Í˳ö¸Ã»î¶¯£¿