Help. I am brand new to Excel, but I need to quickly come up with a
formula to do the following. In any programming language it would be
a simple do while loop, or equivalent, but I can not find out how to
do it in Excel:
Input a Daily Amount, let's say $150 * or call it DA
Multiply it times 365 for a yearly amount
Input a Number of Years, let's say 5 * or call it Y
Multiply the Yearly Amount times the number of years to get a Total
Yearly Amount or call it YA
Input an inflation Rate, let's say 5%* or call it IR
Input a number of Years, let's say 20 * or call it NY
Take the Total Yearly Amount and multiply it by 100% plus the
inflation rate to get an inflated amount. or in a formula (YA x (100
+ IR))
repeat this last calculation once for each of the 20 years.r
In a typical progamming language this would look like this
Counter =1
do while Counter <= NY
YA = (YA x (100 + IR))
Counter = Counter + 1
enddo
I can not find out how to loop or repeat in Excel.
Thanks for any help
Best regards,
Al
http://www.affordablefloridainsurance.com
http://www.americanbestmortgages.com
Bookmarks