Formula needed

[audi]

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

[CLR]

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

Vaya con Dios,
Chuck, CABGx3


"audi" <[email protected]> wrote in message
news:[email protected]...
> 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

[RagDyer]

Try this:

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

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



"audi" <[email protected]> wrote in message
news:[email protected]...
> 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

[Michael Bednarek]

On Tue, 2 Aug 2005 15:09:03 -0700, "audi"
<[email protected]> 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"

[CLR]

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" <[email protected]> wrote in message
news:[email protected]...
> 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