Hello David,
I am working on XL2003, and tried inserting the function in a general
module, but I continue to receive the "#NAME?" error when applying the
formula...
Any quick hint?
Thanks in advance
Gilberto
On Saturday, 11 August 2012 12:56:32 UTC+1, David Grugeon wrote:
> Hi Sharad
>
> Use
HI
*Hope this Will makes some sens for you.*
The word Dim is short for dimmension and is used to declare variables. Now,
while Excel can still work quite happily if we omit the Dim (as long as we
do not have Option Explicit), it comes at a price. Excel MUST store all
undeclared variables as a
Hi David,
Im just getting to grips with VB; could you please let me know what Dim
means? Thanks.
Best
On Saturday, 11 August 2012 15:56:32 UTC+4, David Grugeon wrote:
>
> Hi Sharad
>
> Use the following function in a general module. Then use =Payback(range)
>
> See attached
>
> '===
Hi David,
Thanks a lot for your help on this. Really appreciate.
Best Regards,
Sharad
On Tue, Aug 14, 2012 at 3:19 PM, David Grugeon wrote:
> Sorry. I worked it for each input value being the cash flow for a year.
> I see that you have put down a "Year 0" and the cash flows for the Year 0
>
Hi David,
Though it is working my main sheet. It is giving wrong results.
Can you please recheck? I have attached my actual numbers.
Thanks,
Sharad
On Saturday, August 11, 2012 5:26:32 PM UTC+5:30, David Grugeon wrote:
>
> Hi Sharad
>
> Use the following function in a general module. Then use
Hi Sharad
Use the following function in a general module. Then use =Payback(range)
See attached
'=
Function PayBack(ByRef rng As Range) As Variant
'check that the range has only one dimension
If rng.Rows.Count > 1 And rng.Columns.Count > 1 Then
Pa
Hi Shekar,
Payback is basically a financial tool to see how much it takes to recover
your invest, in other words break even.
If I invest Rs. 100 in one project which gives me following returns - 1
year Rs. 30, 2 year Rs. 40, 3 year Rs. 60. We can see that I recover my
investment / break even
Hi Sharad,
can u explain in brief??, Unable to get what exactly you want
On 10 August 2012 11:32, sharad jain wrote:
> Hi,
>
> I need a formula or macro for calculating payback period which is dynamic.
> I mean that it can calculate the payback period for series of data without
> changing t
Hi,
I need a formula or macro for calculating payback period which is dynamic.
I mean that it can calculate the payback period for series of data without
changing the formula itself again again.
I am attaching an example sheet with 3 scenarios where we can have same
formula / macro.
Will appreci
