Updated Czech translation

[gnumeric.git] / doc / ja / formulas.sgml

<sect1 id="formulas">
        <title>
        ¿ô¼°
        </title>

<para>
¿ô¼°¤Ï¥¹¥×¥ì¥Ã¥É¥·¡¼¥È¤ò»È¤¦¤¢¤é¤æ¤ëÁàºî¤Ë¤«¤«¤ï¤ëÍפǤ¹¡£¿ô¼°¤Ï¡¢Ã±ÆȤοô»ú¡¢¥»¥ë»²¾È¡¢¥»¥ëÈÏ°Ï¡¢¥»¥ëÇÛÎó¤Ê¤É¤ò¤Ï¤¸¤á¤È¤¹¤ë¤¢¤é¤æ¤ë¼ïÎà¤Î°ú¿ô¤ò¼õ¤±¼è¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£
</para>

<sect2>
        <title>
        ¥·¥ó¥¿¥Ã¥¯¥¹
        </title>

<para>
¿ô¼°¤òÄ̾ï¤Î¥Ç¡¼¥¿¤È¶èÊ̤¹¤ë¤Î¤Ï¡¢¡Ö=¡×ʸ»ú¤Ç»Ï¤Þ¤ëÅÀ¤Ç¤¹¡£¡Ö=¡×¤Ç»Ï¤Þ¤ë¥Ç¡¼¥¿¤Ï¤¹¤Ù¤Æ¡¢Ê¸»úÎó¤Ç¤Ï¤Ê¤¯¿ô¼°¤Ç¤¢¤ë¤È²ò¼á¤µ¤ì¤Þ¤¹¡£
</para>

<para>
ºÇ¤âñ½ã¤Ê¿ô¼°¤Ï¡¢É¸½à¤Î¿ô³Ø¤Î±é»»»Ò¤äÉä¹æ¤ò»È¤¦¤â¤Î¤Ç¤¹¡£¡Ö¡Ü¡×¡¢¡Ö¡Ý¡×¡¢¡Ö*¡×¡¢¡Ö/¡×¤Ï¾ï¼±¤É¤ª¤ê¤Ë²ò¼á¤µ¤ì¤Þ¤¹¡£¡Ö¡Ü¡×¤È¡Ö-¡×¤Ï¡¢ÅöÁ³¡¢Ã±¹à±é»»»Ò¤È¤·¤Æ¤âÉä¹æ¤È¤·¤Æ¤â»È¤¦¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£
</para>

<example id="standardoperators">
        <title>
        ɸ½àŪ¤Ê±é»»»Ò¤ÎÎã
        </title>

        <programlisting>
        =5+5            10 ¤òÊÖ¤·¤Þ¤¹¡£
        
        =5-4            1 ¤òÊÖ¤·¤Þ¤¹¡£
        
        =-5             -5 ¤òÊÖ¤·¤Þ¤¹¡£
        
        =5*5            25 ¤òÊÖ¤·¤Þ¤¹¡£
        
        =(5*5)+11       36 ¤òÊÖ¤·¤Þ¤¹¡£
        
        =(5*)+(49/7)    32 ¤òÊÖ¤·¤Þ¤¹¡£
        </programlisting>
</example>
</sect2>

<sect2>
        <title>
        ´Ø¿ô¤Î»È¤¤Êý
        </title>

<para>
¿ô³Ø¡¢¥Ó¥¸¥Í¥¹¡¢Åý·×¡¢²Ê³Ø¤Ê¤É¤Ë¤ª¤±¤ë¤Û¤È¤ó¤É¤Îɸ½àŪ¤Ê·×»»¤Ï¡¢´Ø¿ô¤ò»È¤Ã¤Æ¹Ô¤ï¤ì¤Þ¤¹¡£´Ø¿ô¤Ï¼¡¤Î·Á¼°¤ò¤È¤ê¤Þ¤¹¡£
</para>

<example id="basicfunctionsyntax">
        <title>
        ´Ø¿ô¤Î´ðËÜ¥·¥ó¥¿¥Ã¥¯¥¹
        </title>

        <programlisting>
        =FUNCTION(ARGUMENTS)
        </programlisting>
</example>

<para>
°ìÈÌŪ¤Ëʸ½ñ¾å¤Ç¤Ï¤¹¤Ù¤ÆÂçʸ»ú¤Çɽµ­¤·¤Þ¤¹¤¬¡¢¼ÂºÝ¤ÎÍÑË¡¤È¤·¤Æ¤ÏÂçʸ»ú¤È¾®Ê¸»ú¤Î¶èÊ̤Ϥ¢¤ê¤Þ¤»¤ó¡£
</para>
        
<example id="funxtionsyntax">
        <title>
        ´Ø¿ô¥·¥ó¥¿¥Ã¥¯¥¹¤ÎÎã
        </title>

        <programlisting>
            =SUM(A1,A2,A4,B5)
            
            =AVERAGE(A1:A16)
            
            =EXP(1)
            
            =PI()
            
            =MIN(A1,A2,B6)
        </programlisting>
</example>

<para>
SUM ´Ø¿ô¤Î¤è¤¦¤ËÊ£¿ô¤Î°ú¿ô¤ò¼è¤ë´Ø¿ô¤â¤¢¤ê¤Þ¤¹¡£°ú¿ô¤Î¿ô¤Ë¤Ä¤¤¤Æ¤Ï¡¢¼ÂºÝ¾å̵À©¸Â¤È¤¤¤¨¤Þ¤¹¡£
</para>
</sect2>

<sect2>
        <title>
        ̾Á°
        </title>

<para>
Ê£»¨¤Ê¼°¤â̾Á°¤òÉÕ¤±¤ì¤Ð°·¤¤¤ä¤¹¤¯¤Ê¤ê¤Þ¤¹¡£Ì¾Á°¤Ï¡¢Â¾¤Î¿ô¼°¤ÎÃͤò»Ø¤·¼¨¤·¤Þ¤¹¡£¥»¥ëÈϰϤΥé¥Ù¥ë¤È¤·¤Æ¤â»È¤ï¤ì¤Þ¤¹¡£
</para>

<example id="namesyntax">
        <title>
        ̾Á°¤ò»È¤Ã¤¿Îã
        </title>

<para>
'$A$1:$B$500'¤Î̾Á°¤¬¡ÖDataBase¡×¡¢2.71828182845 ¤Î̾Á°¤¬¡ÖE_Constant¡×¤Ç¤¢¤ë¤È¤¹¤ë¤È¡¢¼¡¤Î¤è¤¦¤Ê¼°¤¬»È¤¨¤Þ¤¹¡£
</para>
        <programlisting>
            =VLOOKUP (C1, "gnu", DataBase, 2, 0)

            =LN(E_Constant)

            =SUM(DataBase, E_Constant)
        </programlisting>
</example>

<para>
̾Á°¤ò¤Ä¤±¤ë¤Ë¤Ï
<guimenu>Insert</guimenu> <guimenuitem>Name</guimenuitem>
¤ò»È¤¤¤Þ¤¹¡£´Ø·¸¤Î¤¢¤ë¥ï¡¼¥¯¥Ö¥Ã¥¯¤ÎÁ´¤Æ¤Î̾Á°¤ò¾å¼ê¤ËÁàºî¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£Ì¾Á°¤Ï¡¢´Ø¿ô¤ÈƱ¤¸Ì¾Á°¤ò»ÈÍѤ¹¤ë¤³¤È¤Ï¤Ç¤­¤Þ¤»¤ó¡£º®Íð¤Î¸µ¤Ç¤¹¡£
</para>

<para>
¤¢¤Ê¤¿¤¬ÄêµÁ¤·¤¿Ì¾Á°¤Î¾¤Ë¡¢¥Ó¥ë¥É¥¤¥ó¤Î̾Á°¤¬¤¢¤ê¤Þ¤¹¡£:
</para>

<itemizedlist>
        <listitem><para>Sheet_Title : ¤³¤Î̾Á°¤ò»ØÄꤹ¤ë¤È¥«¥ì¥ó¥È¡¦¥·¡¼¥È¤Î̾Á°¤òÊÖ¤·¤Þ¤¹¡£</para></listitem>
</itemizedlist>

</sect2>

<sect2>
        <title>
        ÇÛÎó¤Î¿ô¼°
        </title>

<para>
¤µ¤é¤Ë²è´üŪ¤ËÊØÍø¤Ç¡¢¤Þ¤¿É¬Íפʵ¡Ç½¤È¤·¤Æ¡¢°ì¤Ä¤ÎÃͤòÊÖ¤¹¤À¤±¤Ç¤Ê¤¯¡¢¥Þ¥È¥ê¥Ã¥¯¥¹ÃÍ(¹ÔÎó)¤òÊÖ¤¹¼°¤â»È¤¨¤Þ¤¹¡£ºÇ½é¤ÎÎã¤È¤·¤Æ¡¢°ìÈÌŪ¤Ë¹Í¤¨¤é¤ì¤ë¤Î¤Ï¡¢¹ÔÎóÁàºî¡¢¤Ä¤Þ¤ê¡¢¹ÔÎó¤Î¾èË¡¡¢Å¾ÃÖ¡¢µÕ¹ÔÎó¤Î»»½Ð¤Ê¤É¤Ç¤·¤ç¤¦¡£±£¤ì¤¿»È¤¤Êý¤È¤·¤Æ¡¢¥Ç¡¼¥¿Ãê½Ð¥ë¡¼¥Á¥ó(¥Ç¡¼¥¿¥Ù¡¼¥¹¡¢¥ê¥¢¥ë¥¿¥¤¥à¡¦¥Ç¡¼¥¿ÆþÎÏ)¤ä¡¢¥Ù¥¯¥È¥ëÃͤδؿô¡Ê¶ÉÌÌ·×»»¡Ë¤Ê¤É¤¬¤¢¤ê¤Þ¤¹¡£
</para>

<example id="arrayformulacreate">
        <title>
        ÇÛÎó¤Î¿ô¼°¤ÎÆþÎÏ
        </title>

<para>
ÇÛÎó¤Î¿ô¼°¤ò»È¤¦¤Ë¤Ï¡¢·ë²Ì¤òÊݸ¤¹¤ë°ì¤Ä¤ÎÈϰϤòÁªÂò¤·¡¢ÇÛÎó¤Î¿ô¼°¤òÆþÎϤ·¡¢ËâË¡¤Î¥­¡¼¤ÎÁȤ߹ç¤ï¤» <keycap>Ctrl</keycap> + <keycap>Shift</keycap> + <keycap>Enter</keycap> ¤òÆþÎϤ·¤Þ¤¹¡£
</para>

<para>
·ë²Ì¤Ï¼¡¤Î¤è¤¦¤Ëɽ¼¨¤µ¤ì¤Þ¤¹¡£
</para>

        <programlisting>
        ={FUNCTION(ARGUMENTS)}(num_rows, num_cols)[row number][col number]
        </programlisting>
</example>

</sect2>

</sect1>


<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:t
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:2
sgml-indent-data:t
sgml-parent-document:nil
sgml-exposed-tags:nil
sgml-local-catalogs:nil
sgml-local-ecat-files:nil
End:
-->