If 19 is to be 1, then here's my attempt. I have A1 holding your sum of
A+B.

=IF(AND(10<=A1,A1<=19),MOD(A1-1,9)+1,"Not 10-19")

--
Dana DeLouis
Win XP & Office 2003


"Tomas" wrote in message
...
How would I do the following:
A+B = C,
if C = 10 then D = 1
if C = 11 then D = 2
C = 12 then D = 3
and so on
C = 19 then D = 1
thank you!
__________________________________________________ _______________