=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