View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
abhi_23
 
Posts: n/a
Default Price function difference in Output formula vis a vis Manual Calculation


Hi
I am trying to calculate the Price of a bond using the price formula
there apprears to be a difference in the results when the
Price is calculated as per the formula and when one calculates the
Price using the Definition of the Formula ( Excel help ) manually.
Refer the attachments for the sample calculations as well as the
formula definitions
Could any one help me in this regards
Thanks
Abhi


+-------------------------------------------------------------------+
|Filename: Sample for query.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4228 |
+-------------------------------------------------------------------+

--
abhi_23
------------------------------------------------------------------------
abhi_23's Profile: http://www.excelforum.com/member.php...o&userid=30511
View this thread: http://www.excelforum.com/showthread...hreadid=501952