From: Kareem on 19 Apr 2010 03:18 please Sir: if i take salary as 1000 $ per month , and this amout increasing annually by 10% it comes 1100$ then 10 % for next year and so on.... how can i find out the change rate periodcally for 10 years means .. what will be my salary at month in the year 10?? -- Eng.kareem Elsafty
From: Mike H on 19 Apr 2010 03:22 Hi, Starting salary in a1 and then this in A2 and drag down =A1*1.1 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Kareem" wrote: > please Sir: > if i take salary as 1000 $ per month , and this amout increasing annually by > 10% it comes 1100$ then 10 % for next year and so on.... > how can i find out the change rate periodcally for 10 years > means .. what will be my salary at month in the year 10?? > -- > Eng.kareem Elsafty
From: Mike H on 19 Apr 2010 03:28 or to do it in 1 cell =A1*(1.1^10) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mike H" wrote: > Hi, > > Starting salary in a1 and then this in A2 and drag down > > =A1*1.1 > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "Kareem" wrote: > > > please Sir: > > if i take salary as 1000 $ per month , and this amout increasing annually by > > 10% it comes 1100$ then 10 % for next year and so on.... > > how can i find out the change rate periodcally for 10 years > > means .. what will be my salary at month in the year 10?? > > -- > > Eng.kareem Elsafty
From: Joe User on 19 Apr 2010 03:48 "Kareem" <Kareem(a)discussions.microsoft.com> wrote: > if i take salary as 1000 $ per month , and this amout increasing > annually by 10% it comes 1100$ then 10 % for next year and so > on.... how can i find out the change rate periodcally for 10 years > means .. what will be my salary at month in the year 10?? Who knows? You might get fired next year. Just kidding... =FV(10%,10,0,-1000)
|
Pages: 1 Prev: Excel, custom format Next: Top row of excel stays even in sorting |