<HTML
><HEAD
><TITLE
>ACCRINT</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.54"><LINK
REL="HOME"
TITLE="Gnumeric's user manual"
HREF="gnumeric.html"><LINK
REL="UP"
TITLE="Reference"
HREF="function-reference.html#AEN1187"><LINK
REL="PREVIOUS"
TITLE="SUMA"
HREF="r9688.html"><LINK
REL="NEXT"
TITLE="IMTAN"
HREF="r9742.html"></HEAD
><BODY
CLASS="REFENTRY"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Gnumeric's user manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="r9688.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="r9742.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="AEN9713"
><A
NAME="GNUMERIC-ACCRINT"
></A
>ACCRINT</A
></H1
><DIV
CLASS="REFNAMEDIV"
><A
NAME="AEN9718"
></A
><H2
>Name</H2
>ACCRINT&nbsp;--&nbsp;</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><A
NAME="AEN9721"
></A
><H2
>Synopsis</H2
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
WIDTH="100%"
><TR
><TD
><PRE
CLASS="SYNOPSIS"
>ACCRINT(issue,first_interest,settlement,rate,par,frequency[,basis])</PRE
></TD
></TR
></TABLE
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN9723"
></A
><H2
>Description</H2
><P
>ACCRINT calculates the accrued interest for a security that pays periodic interest.  The rate is the annual rate of the security and par is the par value of the security. basis is the type of day counting system you want to use:</P
><P
></P
><P
>0  US 30/360</P
><P
>1  actual days/actual days</P
><P
>2  actual days/360</P
><P
>3  actual days/365</P
><P
>4  European 30/360</P
><P
></P
><P
>If @basis is omitted, US 30/360 is applied. If issue date or settlement date is not valid, ACCRINT returns NUM! error. If @rate or @par is zero or negative, ACCRINT returns #NUM! error. If @basis &#60; 0 or @basis &#62; 4, ACCRINT returns #NUM! error. If issue date is after maturity date or they are the same, ACCRINT returns #NUM! error. </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN9734"
></A
><H2
>Examples</H2
><P
></P
><P
></P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN9738"
></A
><H2
>See also</H2
><P
>        <A
HREF="r8984.html#GNUMERIC-ACCRINTM"
>ACCRINTM</A
>
      </P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="r9688.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="gnumeric.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="r9742.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
NAME="GNUMERIC-SUMA"
></A
>SUMA</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="function-reference.html#AEN1187"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
NAME="GNUMERIC-IMTAN"
></A
>IMTAN</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>