IF / OR Functions

Hi,

I am trying to get Excel to insert the number 2 (onto a scorecard) when a number falls between 2 ranges.

Essentially what I want it to do is if the number falls between 350 - 550 or 650 - 800 then excel will automatically insert the number 2.

It is currently working when the number falls between 650 - 800 but not 350 - 550

This is what I have:

=IF(OR(C2>349,C2<=550)*IF(C2>650,C2<=800),"2","")

Any help would be much appreciated