Forum Discussion
Solved
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 -...
Hi Sam,
=IF(OR(AND(C2>349,C2<=550),AND(C2>650,C2<=800)),"2","")
Hi Sam,
=IF(OR(AND(C2>349,C2<=550),AND(C2>650,C2<=800)),"2","")
That is perfect. Thanks so much Sergei