G Guest Apr 26, 2006 #1 Want to increase number by 1% each year for first 3 years and the thereafter ther will be no increase for next 4 years
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 Apr 26, 2006 #2 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:
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:
