I'm in a proper tangle over a combination formula.

If A1=1 or 4 or 7, then "1" but if a1=2 or 5 or 8, then "2", if A1=3 or 6 or 9, then "3", otherwise "x"

I should be able to do it, but it's eluding me with "too many arguments" coming up...

Many thanks, people