Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MTD Rating | Excel Worksheet Functions | |||
Compute a rating of a mtd average compared to a rating scale | Excel Discussion (Misc queries) | |||
Rating | Excel Worksheet Functions | |||
RAG Rating | Charts and Charting in Excel | |||
Rating 1 to 10 | Excel Discussion (Misc queries) |