Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Which method would be faster? One using raw Excel, or one going through an
addin function? Obviously it would depend on the user's needs. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Bernard Liengme" wrote in message ... So you could also use =TBILLPRICE(....)*360/365 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Andy Wiggins" wrote in message ... According to the Help file, the formula to calculate TBILLPRICE is: 100*(1-discount%*(Maturity Date - Settlement Date)/360). Use this instead of the provided function and change 360 to 365. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "ASHAR ZUKA FAROOQI" <ASHAR ZUKA wrote in message ... In Pakistan we calculate T- bill Prices on the basis of 365 yaers a day. In the formual of T-bill Price the basis of 360 days a year. So we found an error of calculation. Please advice me. Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i calculate principal payed in one year in excel | New Users to Excel | |||
days in a year | Excel Worksheet Functions | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
HOW TO CALCULATE THE DAYS? | Excel Worksheet Functions |