That was the answer I gave the OP last Friday, but it didn't seem to do
the trick. Given the mathematical impossibility in the problem
statement, I'm darned if I can figure out what is wanted, however...

In article ,
"Dana DeLouis" wrote:

Seems like a form of Mod would work:
=MOD(A1+B1-1,9)+1