enter:

1 in A1
2 in A2
3 in A3

etc.

Then in B1 enter:
=(A1+1)*10 and copy down
--
Gary''s Student - gsnu200731


"Chantz" wrote:

I am trying to get a formula for my chart and am having no luck - with all
the formulas I enter (using IF, SUM, etc) nothing seems to work out.

So if someone could please tell me how to acheive my results I would greatly
appreciate it (please include which formula I should select (ie: IF, SUM)

I have 2 columns - one column I want to be able to put a year value (ie: 1,
2, 3) and in the next column I want it to automatically put the appropriate
number for the year I entered.
Example:
1 = 20
2 = 30
3 = 40

Any help with this would be greatly appreciated.

Thank you