On Tue, 2 Aug 2005 15:09:03 -0700, "audi"
wrote in microsoft.public.excel.misc:

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?

--
Michael Bednarek http://mbednarek.com/ "POST NO BILLS"