writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + Line 6:
Line 6: − TBILLEQ() calculates the price per $100 face value for a Treasury Bill.+ − TBILLEQ(SettlementDate, MaturityDate, Discount)+
Manuals/calci/TBILLPRICE (view source)
Revision as of 22:32, 28 February 2014
, 22:32, 28 February 2014no edit summary
=TBILLEQ(SettlementDate, MaturityDate, Discount)=
=TBILLPRICE(SettlementDate, MaturityDate, Discount)=
where,
where,
*<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.
== Description ==
== Description ==
TBILLPRICE(SettlementDate, MaturityDate, 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>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.