Appreciate the feed-back.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Juco" wrote in message
k...
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
|