HELP!! Multiple Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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....
 
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....
Click to expand...

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.
 
=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,

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
 
Back
Top