I'm sure this is ridiculously simple. I'm trying to put Opportunities into groups based on Age
This is the formula I've written
IF(Opportunity_Age__c < 100, "Short Term", IF( OR( Opportunity_Age__c >= 100,Opportunity_Age__c <= 249, "Mid Term", IF( OR( Opportunity_Age__c >= 250,Opportunity_Age__c <= 365, "Long Term", IF( Opportunity_Age__c >= 366, "365+", NULL))))))
I'm getting the error below on the third line at "Long Term"
Error: Incorrect parameter type for function 'OR()'. Expected Boolean, received Text
Can someone tell me 1, why I'm getting this error message, and 2, is there a better method?
I thought CASE might work better but I'm not sure if you can use that for ranges