Hi Everyone - can any of you help me with this question in my assignment?
I'd be very grateful for any assistance!
. Write a function named PValue(cfs, per, r) that returns the present value of a set of cash flows contained in the range cfs (cfs can be either a row or a column.). The range per contains the periods in which each cash flow occurs (e.g. the first cash flow in cfs occurs in period 2, the second cash flow is in period 5). The discount rate is r per period. Do not use any Excel functions within PValue().
When I use the following formula (to find the density at X times the standard deviation, in this case X = 5):
=(NORMSDIST(5)-NORMSDIST(5-0.0000000001))/0.0000000001
excel (I tried in 2003 and 2007) gives the wrong answer (~ -0.003).
For X = 4.9 and 5.1 (for instance) the answers are correct. For X = -5 (which should give the same answer as X = 5) the answer is also correct.
Anybody know how to solve this? Thanks in advance!
I am trying to use NormSInv(Rnd) and get the following error when I try to compile my code. I don't know why though...when you type normsinv, VBA changes it to NormSInv so it does recognize it as a function.
"Compile error:
Sub or Function not defined"
=IF(G8>=2000,S47,G8/2000*S47)+(((N6+R6)/2)*((IF(G26="RCG",0.05,0)+IF(G28="RCG",0.025,0)))+((V42*0.1)*(G8*1000)))
Assuming:
G8 = 4000
S47 = 2453
N6 = 39000
R6 = 85800
G26 = RCG
G28 = RCG
V42 = 0.62%
Answer should be = 9629
PLZ anybody solve it step by step.
Hi all, I work for a not for profit theatre and I'm trying to put together a calendar that shows the following:
- Show (as what the production name is)
- It's season start date
- A series of actions that need to be undertaken to ensure deadlines are met for marketing etc AND these actions need to occur in sequence working back from the show season start date.
For example, the mailout is to occur 4 weeks prior to the show start date, therefore the cell needs to calculate the date 4 weeks back from 'show start date' which is the ultimate / target date of course. There are a series of about 10 actions that need to occur and they all have set timeframes in place that work back from the show date.
The purpose of this spreadsheet is to have a resource that can be used on a weekly basis to show where things need to be for each show. I am using Excel 2003.
I appreciate any assistance on this, I for the life of me cannot work it out alone!!
Tim
Hi All,
I am really confused and toiled on a project which requires 2 major automizations, please help if you can I would really appriciate your help:
O/S used: Win 2000
1) I require a macro to send an excel sheet copied as a whole in an outlook message box and also attach one more excel sheet but as an attachment in the same mail, with specified subject line and specified distribution list from outlook.
2) I was also looking for a macro which would help me update an excel database with live udates from a database.
I would really and greatly appriciate your help.
Thank You for your consideration,
Hi All,
I already posted this in the Worksheet Functions thread but I'm not sure if
that was the right place?
Anyway here is my question......
Why is
1-NORMSDIST(7.8) = 3.10862e-15
while
1-NORMSDIST(7.9) = 0
Is there a limit to how far out the Gaussian PDF curve you can go before
Excel rounds to zero?
Thanks
Barry
i have a task of producing a spreadsheet that asks questions and takes figures then displays them as a report.
e.g how much is your energy bill? the user types a figure, its calculated in a formula, and the results displayed in a report.
I need it set out so it looks professional and user friendly. Has anyone got any examples of well laid out user friendly colourful spreadsheets?
Would appriciate it if some one could help me.
Thanks a great deal
Hi,
I am using excel 2003, with the function "NORMSDIST".
A1 = NORMSDIST(1.33) = 0.908240864349719
B1 = (1/Sqrt(2*pi()) * exp(- 1.33^2 / 2) = 0.164739715373077
since f(x) = 1/(2* Pi)^.5 * e^-1/2 * x^2
But the two are not the same? Do you know what the problem is?
Thanks
