Dear Chandoo,
I liked the rent or buy calculator; at the same time I was not able to quickly infer from the NPV which is best - rent or buy. I added a quick summary (rent paid, interest paid, value appreciation of property & opportunity lost on down payment) and arrived at net gain.
It looks...
Thanks for the tip, I used randbetween(1000000000,9999999999) and then used "remove duplicate" function in excel 2007 to eliminate duplicates, bingo, the 3 million codes were generated.
Hi,
For a project, I need to generate unique, non serialised random numbers - in fact, I need to generate 30 lakh such codes,with ten digits.
Is this possible in excel 2007 and if so, how?
thx in advance
rgds
AR Augustine
Hi,
I have a slab based benefit as below.
slab (up to) Rs Payout
1000 1
2000 2
5000 3
> 4
How do I write a formula in excel to pick up the correct benefit as per the slab above?
thx and rgds