Excel 2000 -

S

shirleycu

Doing an online course in Excel and question is: second year expenses are
first year expenses increased by 3%. I don't understand how to get the
answer when I only have the first year expenses in the worksheet. Not sure
what the formula is?
 
D

Douglas J Steele

I think you'd be better off asking in a newsgroup related to Excel.

This newsgroup is for questions about Access, the database product that's
part of Office Professional.
 
E

Ed Warren

You're asking a high school math (word problem) not an excel problem.

FirstYear = 100
SecondYear = "FirstYear increased by 3%" => FirstYear + .03*FirstYear =>
1.03*(FirstYear)
So in your excel spreadsheet you will type: =1.03 * A1 (assuming your first
year value is stored in cell A1)
SecondYear = 103
Ed Warren
 
Top