Formula needed

[Guest]

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

 

[RagDyer]

Try this:

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

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

 

[Michael Bednarek]

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?

 

[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