I made this and it works in my tests: if(Compliance Deadline > $$TODAYb+9m,2, if(Compliance Deadline > $$TODAYb+6m,5, if(Compliance Deadline > $$TODAYb+3m,8, If(Compliance Deadline >= $$TODAYb,10,0)))) If I'm looking at it correctly, the closed parentheses after your statement was causing the proble...