That exact formula gives me a syntax error saying that there are extra characters at the end of the function. I tried:
IF(
year(today())-year([hire date]) >=9,"200",
year(today())-year([hire date]) >=3,"160",
year(today())-year([hire date]) =2,"120",
year(today())-year([hire date]) =1,Month(Today())+1,
year(today())-year([hire date]) =0, (Month(today())-Month([hire date]) * 10))
and get that there are not enough arguments for an If function, so I tried this:
IF(
year(today())-year([hire date]) >=9,"200",
year(today())-year([hire date]) >=3,"160",
year(today())-year([hire date]) =2,"120",
year(today())-year([hire date]) =1,Month(Today())+1,
year(today())-year([hire date]) =0, (Month(today())-Month([hire date]) * 10),0)
And I'm still getting Formula error - bad or missing arguments in function call.