If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rating
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 |
#2
|
|||
|
|||
Rating
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 |
#3
|
|||
|
|||
Rating
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 |
#4
|
|||
|
|||
Rating
"Kareem" 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) |
Thread Tools | |
Display Modes | |
|
|