Formula needed

A

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
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
R

RagDyer

Try this:

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

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

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
Click to expand...

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

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
 
Top