excelÖÐÊýѧºÍÈý½Çº¯Êý ÏÂÔØ±¾ÎÄ

Number ΪÐèҪת»»µÄ°¢À­²®Êý×Ö¡£

Form ΪһÊý×Ö£¬Ö¸¶¨ËùÐèµÄÂÞÂíÊý×ÖÀàÐÍ¡£ÂÞÂíÊý×ÖµÄÑùʽ·¶Î§¿ÉÒÔ´Ó¾­µäµ½¼ò»¯£¬Ëæ×Å form ÖµµÄÔö¼ÓÇ÷ÓÚ¼òµ¥¡£Çë²Î¼ûÏÂÃæµÄʾÀý ROMAN(499,0)¡£ Form

0 »òÊ¡ÂÔ ¾­µä¡£ 1 2 3 4 TRUE FALSE ˵Ã÷

Èç¹ûÊý×ÖΪ¸º£¬Ôò·µ»Ø´íÎóÖµ #VALUE!¡£

? Èç¹ûÊý×Ö´óÓÚ 3999£¬Ôò·µ»Ø´íÎóÖµ #VALUE!¡£

?

ÀàÐÍ

¸ü¼òÃ÷¡£Çë¼ûÏÂÀý¡£ ¸ü¼òÃ÷¡£Çë¼ûÏÂÀý¡£ ¸ü¼òÃ÷¡£Çë¼ûÏÂÀý¡£ ¼ò»¯¡£ ¾­µä¡£ ¼ò»¯¡£

ʾÀý

Èç¹ûÄú½«Ê¾Àý¸´ÖƵ½¿Õ°×¹¤×÷±íÖУ¬¿ÉÄÜ»á¸üÒ×ÓÚÀí½â¸ÃʾÀý¡£

²Ù×÷·½·¨

1. ´´½¨¿Õ°×¹¤×÷²¾»ò¹¤×÷±í¡£

2. ÇëÔÚ¡°°ïÖú¡±Ö÷ÌâÖÐѡȡʾÀý¡£²»ÒªÑ¡È¡ÐлòÁбêÌâ¡£

´Ó°ïÖúÖÐѡȡʾÀý¡£

3. °´ Ctrl+C¡£

4. ÔÚ¹¤×÷±íÖУ¬Ñ¡Öе¥Ôª¸ñ A1£¬ÔÙ°´ Ctrl+V¡£ 5. ÈôÒªÔڲ鿴½á¹ûºÍ²é¿´·µ»Ø½á¹ûµÄ¹«Ê½Ö®¼äÇл»£¬Çë°´ Ctrl+`£¨ÖØÒô·û£©£¬»òÔÚ¡°¹¤¾ß¡±²Ëµ¥ÉÏ£¬Ö¸Ïò¡°¹«Ê½ÉóºË¡±£¬ÔÙµ¥»÷¡°¹«Ê½ÉóºËģʽ¡±¡£ 1

A ¹«Ê½

B ˵Ã÷£¨½á¹û£©

2 =ROMAN(499,0) 499 µÄ¹ÅµäÂÞÂíÊý×ÖÑùʽ (CDXCIX) 3 =ROMAN(499,1) 499 µÄ¼òÃ÷°æ (LDVLIV)

49

4 =ROMAN(499,2) 499 µÄ¼òÃ÷°æ (XDIX) 5 =ROMAN(499,3) 499 µÄ¼òÃ÷°æ (VDIV) 6 =ROMAN(499,4) 499 µÄ¼òÃ÷°æ (ID)

7 =ROMAN(2013,0) 2013 µÄ¹ÅµäÂÞÂíÊý×ÖÑùʽ (MMXIII)

ROUND

·µ»ØÄ³¸öÊý×Ö°´Ö¸¶¨Î»ÊýÈ¡ÕûºóµÄÊý×Ö¡£ Óï·¨

ROUND(number,num_digits)

Number ÐèÒª½øÐÐËÄÉáÎåÈëµÄÊý×Ö¡£

Num_digits Ö¸¶¨µÄλÊý£¬°´´ËλÊý½øÐÐËÄÉáÎåÈë¡£ ˵Ã÷

Èç¹û num_digits ´óÓÚ 0£¬ÔòËÄÉáÎåÈëµ½Ö¸¶¨µÄСÊýλ¡£ ? Èç¹û num_digits µÈÓÚ 0£¬ÔòËÄÉáÎåÈëµ½×î½Ó½üµÄÕûÊý¡£ ? Èç¹û num_digits СÓÚ 0£¬ÔòÔÚСÊýµã×ó²à½øÐÐËÄÉáÎåÈë¡£

?

ʾÀý

Èç¹ûÄú½«Ê¾Àý¸´ÖƵ½¿Õ°×¹¤×÷±íÖУ¬¿ÉÄÜ»á¸üÒ×ÓÚÀí½â¸ÃʾÀý¡£

²Ù×÷·½·¨

1. ´´½¨¿Õ°×¹¤×÷²¾»ò¹¤×÷±í¡£

2. ÇëÔÚ¡°°ïÖú¡±Ö÷ÌâÖÐѡȡʾÀý¡£²»ÒªÑ¡È¡ÐлòÁбêÌâ¡£

´Ó°ïÖúÖÐѡȡʾÀý¡£

3. °´ Ctrl+C¡£

4. ÔÚ¹¤×÷±íÖУ¬Ñ¡Öе¥Ôª¸ñ A1£¬ÔÙ°´ Ctrl+V¡£

50