Thanks for the help,
it works a treat.

thank you both
Juco


"Ragdyer" wrote in message
...
Another way:
Enter in M7:

=(OR(C8={1,2,3,4})*200+(OR(C8={5,6}))*250)
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

"Juco" wrote in message
k...
I am trying to get this to work...
IF C8 = 1 or 2 or 3 or 4 then print 200 in cell M7
IF C8 = 5 or 6 then print 250 in cell M7

I have tried various ways (hopeless at formulas) but can`t get it to
work
for me.
help appreciated
thanks