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