| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Price Function
Hey Guys:
Can anyone tell me how Excel pricing ACT/365 using Price formula? Because If I do it manually, I don't get the same answer. I have looked at the help on Price and plug the number into the formula they provided , still no luck. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Price Function
Have a look in the help: the formula used by Excel is clearly shown...
"snowsnow" <snowsnow @discussions.microsoft.com schreef in bericht ... Hey Guys: Can anyone tell me how Excel pricing ACT/365 using Price formula? Because If I do it manually, I don't get the same answer. I have looked at the help on Price and plug the number into the formula they provided , still no luck. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Price Function
Sorry... Didn't read good enough... Can't help...
"snowsnow" <snowsnow @discussions.microsoft.com schreef in bericht ... Hey Guys: Can anyone tell me how Excel pricing ACT/365 using Price formula? Because If I do it manually, I don't get the same answer. I have looked at the help on Price and plug the number into the formula they provided , still no luck. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Price Function
The problem I am facing is that, if I chose ACT/ACT and I do my manual
calculation using ACt/ACT day count I got the same answer as EXCEL. However if I do ACT/365, my answer is different to what EXCEL provided. "Frederik" wrote: Sorry... Didn't read good enough... Can't help... "snowsnow" <snowsnow @discussions.microsoft.com schreef in bericht ... Hey Guys: Can anyone tell me how Excel pricing ACT/365 using Price formula? Because If I do it manually, I don't get the same answer. I have looked at the help on Price and plug the number into the formula they provided , still no luck. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Price Function
Want to give some numbers?
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "snowsnow" wrote in message ... The problem I am facing is that, if I chose ACT/ACT and I do my manual calculation using ACt/ACT day count I got the same answer as EXCEL. However if I do ACT/365, my answer is different to what EXCEL provided. "Frederik" wrote: Sorry... Didn't read good enough... Can't help... "snowsnow" <snowsnow @discussions.microsoft.com schreef in bericht ... Hey Guys: Can anyone tell me how Excel pricing ACT/365 using Price formula? Because If I do it manually, I don't get the same answer. I have looked at the help on Price and plug the number into the formula they provided , still no luck. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
| Price Function Error? | Excel Worksheet Functions | |||
| Financial Function : Price | Excel Discussion (Misc queries) | |||
| calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
| create a formula for price * discount* tax =final price | Excel Discussion (Misc queries) | |||
Linear Mode
