format cell formula

[Juco]

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

 

[Guest]

Hi, Juco;
I didn't see anything in your actual question to do with formatting, but
here is one answer to the question: use the IF function with the OR function
for its first argument, 200 for its second, and another IF function for its
third. Use another OR function for the first argument in the second IF
function, 250 for the second, and "" for the third ("" returns blank). So:
=IF(OR(C8=1,C8=2,C8=3,C8=4),200,IF(OR(C8=5,C8=6),250,""))
Regards,
Ian.

 

[Ragdyer]

Another way:
Enter in M7:

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

 

[Juco]

Thanks for the help,
it works a treat.

thank you both
Juco

 

[Ragdyer]

Appreciate the feed-back.