Excel 2000 -

[Guest]

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?

 

[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.

 

[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