excel formulas

[Michael]

Can someone help me with how to create a formula that looks at one cell and
based upon the number in that cell (if statement) then gives me another
number?

example:

If cell c4 contains the number 1; then how can I have cell a8 look at cell
c4 and give me the number 1 (other than a link) / then have cell a9 look at
cell c4 if it contains the number 2 to then give me the number
2....................

I need a formula to look at a cell that will contain a number from 1 to 5 or
above and then accoridingly give me a coresponding number to reflect if that
number is 1,2,3,4 or 5. Each cell number will have a different $ amount
based upon each number or show a "0" if the number is greater than 6. Does
this make any sense?

 

[Sheeloo]

In A8 enter
=LOOKUP(A4,{1,2,3,4,5},{100,200,300,400,500})

This will give you 100, 200 and so on if value in A4 is 1, 2, ...

You can replace {100,200,300,400,500} by the values you want. You can adapt
this to various cells.


If cell c4 contains the number 1; then how can I have cell a8 look at cell