Hi! I’m looking for help with an If formula. I want the end result to be:

• 
  

  If Column A says 5, then Column B will display “Now”

  
  


• 
  

  If Column A says 4 or 3, then Column B will display “Soon”

  
  


• 
  

  If Column A says 2 or 1, then Column B will display “Later”

  
  

The formula I used was: IF({Ranking (from Projects)}=5, “NOW ”, IF(OR({Ranking (from Projects)}=4, {Ranking (from Projects)}=3), “SOON ”, “Later ”))

But some of my fields with Column A that says 5, says Later. Do you know what I did wrong? Thanks!