# 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* | [Required] Settlement date for the security. |
| *mature* | [Required] Maturity date for the security. |
| *discount* | [Required] Amount invested in the security. |
| *redeem* | [Required] Amount to be received at maturity. |
| *basis* | [Optional] Integer representing the basis for day count |

## 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.

## 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