HELP!! Multiple Formula
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
|