increase number with 1%

G

Guest

Want to increase number by 1% each year for first 3 years and the thereafter
ther will be no increase for next 4 years
 
G

Guest

I suppose you have somewhere the actual number of years. If so and I
understood you well

=A1*1.01^IF(B1<=3,B1,3)

where A1 contains the number to be increased
B1 contains the actual number of years


Regards,
Stefi

„Nitin gupta†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

variable annual wage increases based on start date 7
Excel formula to incrementally increase a value by 1 every 365 day 2
dynamic cell number 2
Excel Formula Help? 6
Starting payment when increase rate is known & total payment is kn 12
Streaming boosts 16.5% rise in US recorded music revenues 4
assign a number to the same date & start over with 1 on new date 3
Time Value of Money 1

Top