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
|