Formula needed
 

Please advise how I can come about a formula for the following.

If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700

1=400
2=500
3=600
4=700

Thank you in advance for your help.
Audi

=IF(N9=1,400,IF(N9=2,500,IF(N9=3,600,IF(N9=4,700," "))))

Vaya con Dios,
Chuck, CABGx3


"audi" wrote in message
...
Please advise how I can come about a formula for the following.

If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700

1=400
2=500
3=600
4=700

Thank you in advance for your help.
Audi

Try this:

=CHOOSE(N9,400,500,600,700)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"audi" wrote in message
...
Please advise how I can come about a formula for the following.

If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700

1=400
2=500
3=600
4=700

Thank you in advance for your help.
Audi

On Tue, 2 Aug 2005 15:09:03 -0700, "audi"
wrote in microsoft.public.excel.misc:

Please advise how I can come about a formula for the following.

If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700

1=400
2=500
3=600
4=700

Maybe I'm missing something here, but wouldn't
=(N9+3)*100
in O9 do that?

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"

All three of the responses give the correct results if N9 contains 1,2,3 or
4.........the difference being what result you would like returned if N9 is
empty, contains another number or zero or a decimal number, or even TEXT.

Vaya con Dios,
Chuck, CABGx3


"audi" wrote in message
...
Please advise how I can come about a formula for the following.

If (cell) N9=1,2,3 or 4 then (cell) O9=400, 500, 600, 700

1=400
2=500
3=600
4=700

Thank you in advance for your help.
Audi