[]

SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer Component
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
    - ACCRINT
    - ACCRINTM
    - AMORDEGRC
    - AMORLINC
    - COUPDAYBS
    - COUPDAYS
    - COUPDAYSNC
    - COUPNCD
    - COUPNUM
    - COUPPCD
    - CUMIPMT
    - CUMPRINC
    - DB
    - DDB
    - DISC
    - DOLLARDE
    - DOLLARFR
    - DURATION
    - EFFECT
    - FV
    - FVSCHEDULE
    - INTRATE
    - IPMT
    - IRR
    - ISPMT
    - MDURATION
    - MIRR
    - NOMINAL
    - NPER
    - NPV
    - ODDFPRICE
    - ODDFYIELD
    - ODDLPRICE
    - ODDLYIELD
    - PDURATION
    - PMT
    - PPMT
    - PRICE
    - PRICEDISC
    - PRICEMAT
    - PV
    - RATE
    - RECEIVED
    - RRI
    - SLN
    - SYD
    - TBILLEQ
    - TBILLPRICE
    - TBILLYIELD
    - VDB
    - XIRR
    - XNPV
    - YIELD
    - YIELDDISC
    - YIELDMAT
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
  - Web Functions
  - Other Functions
  - RegEx Functions
Import and Export Reference
Frequently Used Events
API Documentation
Release Notes

RECEIVED

This function returns the amount received at maturity for a fully invested security.

Syntax

RECEIVED(settle, mature, invest, discount, basis)

Arguments

This function has these arguments:

Argument	Description
settle	Settlement date for the security
mature	Maturity date for the security
invest	Amount invested in the security
discount	Discount rate for the security
basis	[Optional] Integer representing the basis for day count (Refer to Day Count Basis.)

Remarks

This function returns a #VALUE! error when settle or mature is invalid. Settle, mature, and basis are truncated to integers.

The function returns an error in the following cases:

If invest or discount is less than or equal to 0, a #NUM! error is returned.
If basis is less than 0 or greater than 4, a #NUM! error is returned.
If settle is greater than or equal to mature, a #NUM! error is returned.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

RECEIVED(A1,B2,C3,C4,1)

RECEIVED("3/01/2004","6/01/2004",600000,0.03,2) gives $604,635.50