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

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

I should clarify...
In the column per cell it will be either 1, 2 or 3 and when I type one of
these 3 numbers I would like it to automatically change to the dollar value
per the year entered.
As stated 1=$20, 2=$30, 3=$40



"Gary''s Student" wrote:

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

Format Cell B1 Choose currency Set Decimal places to 0
Copy down

Bob M.


"Gary''s Student" wrote:

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

It is actually the formula I need not how to get the column to be 'currency'
format.
What I am working with is contracts (1yr, 2yr, 3yr) and each year is worth a
different amount. I want to be able to enter in 1, 2 or 3 in a cell (column
1) and in turn it will automatically enter the value in the cell (column 2)
beside it.

For Example

Column 1 Column 2
Contract Term Contract Value
_____________________________
1 20
3 40
2 30
3 40

Etc....


"robert morris" wrote:


Format Cell B1 Choose currency Set Decimal places to 0
Copy down

Bob M.


"Gary''s Student" wrote:

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

It is actually the formula I need not how to get the column to be
'currency'
format.
What I am working with is contracts (1yr, 2yr, 3yr) and each year is worth
a
different amount. I want to be able to enter in 1, 2 or 3 in a cell
(column
1) and in turn it will automatically enter the value in the cell (column
2)
beside it.

For Example

Column 1 Column 2
Contract Term Contract Value
_____________________________
1 20
3 40
2 30
3 40

Etc....

As long as your contract terms are whole numbers (and never 0 or negative),
you could probably use this...

=CHOOSE(A1,10,20,30)

Rick

But this formula doesn't tell it what makes it 20, 30, 40 - by having to
specify the year.


"Rick Rothstein (MVP - VB)" wrote:

It is actually the formula I need not how to get the column to be
'currency'
format.
What I am working with is contracts (1yr, 2yr, 3yr) and each year is worth
a
different amount. I want to be able to enter in 1, 2 or 3 in a cell
(column
1) and in turn it will automatically enter the value in the cell (column
2)
beside it.

For Example

Column 1 Column 2
Contract Term Contract Value
_____________________________
1 20
3 40
2 30
3 40

Etc....

As long as your contract terms are whole numbers (and never 0 or negative),
you could probably use this...

=CHOOSE(A1,10,20,30)

Rick

=CHOOSE(A1,10,20,30)

The first argument (the A1 cell reference) is an index into the list
following it. If A1 contains 1, then the first item in the list is used; if
A1 contains 2, then the second item in the list is used; if A1 contains 3,
then the third item in the list is used, and so on for as many items as is
in the list. For your shown example,

Column 1 Column 2
Contract Term Contract Value
_____________________________
1 20
3 40
2 30
3 40

you would use this in B1....

=CHOOSES(A1,20,30,40)

and copy it down. Just put in the values you want for 1,2,3,etc., in order,
in arguments 2 through as many contract terms as you can possibly have.

Rick



"Chantz" wrote in message
...
But this formula doesn't tell it what makes it 20, 30, 40 - by having to
specify the year.


"Rick Rothstein (MVP - VB)" wrote:

It is actually the formula I need not how to get the column to be
'currency'
format.
What I am working with is contracts (1yr, 2yr, 3yr) and each year is
worth
a
different amount. I want to be able to enter in 1, 2 or 3 in a cell
(column
1) and in turn it will automatically enter the value in the cell
(column
2)
beside it.

For Example

Column 1 Column 2
Contract Term Contract Value
_____________________________
1 20
3 40
2 30
3 40

Etc....

As long as your contract terms are whole numbers (and never 0 or
negative),
you could probably use this...

=CHOOSE(A1,10,20,30)

Rick