Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMIF function in "Price quote with tax calculation" templae Peter Excel Worksheet Functions 6 October 3rd 05 07:18 PM
Formula for calculating price nander Excel Discussion (Misc queries) 1 August 4th 05 09:19 PM
Manual or Formula entry in cell. Naz Excel Discussion (Misc queries) 0 May 24th 05 10:44 PM
Function Formula is displayed not results iloveexcellllll Excel Worksheet Functions 0 January 11th 05 02:29 AM
how to enter a formula using column() function for a range Mike Peter Excel Worksheet Functions 6 December 8th 04 07:11 AM


All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"