$$Excel-Macros$$ Re: Locking Only Selected Cell

2012-09-16 Thread Sj
Thanks a lot experts On Friday, September 14, 2012 5:08:06 PM UTC+5:30, Sj wrote: > > Dear Experts, > > Can someone please let me know how to lock only selected cell? > > Thanks, > Sharad > -- Join official facebook page of this forum @ https://www.facebook.com/discuss

Re: $$Excel-Macros$$ Excel Chart of Four Quadrants

2012-08-26 Thread Sj
Hi Ashish, Thanks a lot for this. But I was looking forward to a four quadrants. Also does this file support more data rows? Regards, Sharad On Saturday, August 25, 2012 1:59:12 PM UTC+5:30, ashish wrote: > > check the attachment > > On Thu, Aug 23, 2012 at 4:23 PM, sharad jain > > wrote: >

Re: $$Excel-Macros$$ payback Period Formula / Macro

2012-08-14 Thread Sj
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

Re: $$Excel-Macros$$ payback Period Formula / Macro

2012-08-10 Thread Sj
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