Changes

=TBILLPRICE(SettlementDate, MaturityDate, Discount)=

<div style="font-size:30px">'''TBILLPRICE (Settlement,Maturity,Discount)'''</div><br/>

 

where,  

where,  

*<math>SettlementDate</math> is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)

*<math>Settlement</math> is the Treasury Bill's settlement date (a date when the Treasury Bill is purchased)

*<math>MaturityDate</math> is the Treasury Bill's maturity date (a date when the Treasury Bill expires)

*<math>Maturity</math> is the Treasury Bill's maturity date (a date when the Treasury Bill expires)

*<math>Discount</math> is the Treasury Bill's discount rate.

*<math>Discount</math> is the Treasury Bill's discount rate.

TBILLPRICE() calculates the price per $100 face value for a Treasury Bill.

TBILLPRICE(), returns the price per $100 face value for a Treasury bill.

== Description ==

== Description ==

TBILLPRICE(SettlementDate, MaturityDate, Discount)

TBILLPRICE (Settlement,Maturity,Discount)

*<math>SettlementDate</math> and <math>MaturityDate</math> should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.

*<math>Settlement</math> and <math>Maturity</math> should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.

*If <math>SettlementDate</math> &gt;= <math>MaturityDate</math>, Calci displays #N/A error message.

*If <math>SettlementDate</math> &gt;= <math>Maturity</math>, Calci displays #N/A error message.

*<math>MaturityDate</math> should not be greater than one year from <math>SettlementDate</math>. Else, Calci displays #N/A error message.

*<math>Maturity</math> should not be greater than one year from <math>Settlement</math>. Else, Calci displays #N/A error message.

*If <math>Discount</math> &lt;=0, Calci displays #N/A error message.

*If <math>Discount</math> &lt;=0, Calci displays #N/A error message.

*Formula:  

*Formula: