=CHOOSE(N9,400,500,600,700)
--
Gary's Student


"audi" wrote:

If N9=1 2 3 or 4 then I would like cell O9 to = 400, 500, 600, 700

1=400
2=500
3=600
4=700

PLEASE ADVISE, THANKS