Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF function in "Price quote with tax calculation" templae | Excel Worksheet Functions | |||
Formula for calculating price | Excel Discussion (Misc queries) | |||
Manual or Formula entry in cell. | Excel Discussion (Misc queries) | |||
Function Formula is displayed not results | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |