ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Price function difference in Output formula vis a vis Manual Calculation (https://www.excelbanter.com/excel-worksheet-functions/65567-price-function-difference-output-formula-vis-vis-manual-calculation.html)

abhi_23

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



All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com