View Single Post
  #1   Report Post  
Juco
 
Posts: n/a
Default format cell formula

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