# PRICEDISC

## Content

This function returns the price per $100 face value of a discounted security.

## Syntax

`PRICEDISC(settle, mature, discount, redeem, basis)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *settle* | Settlement date for the security. |
| *mature* | Maturity date for the security. |
| *discount* | Amount invested in the security. |
| *redeem* | Amount to be received at maturity. |
| *basis* | [Optional] Integer representing the basis for day count (Refer to [Day Count Basis](/spreadjs/docs/v17/formulareference/formulaoverview/functionsformula/DayCountBasis).) |

## Remarks

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

* If *discount* or *redeem* 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

`PRICEDISC(A1,A2,A5,A7,1)`

`PRICEDISC(R1C1,R2C1,R5C5,R5C7,2)`

`PRICEDISC("5/15/2004","9/1/2004",0.06,100,3)` gives the result 98.20822