Peo,
I'd like to ask you for some further help with ceating a formula for:
A1 + A2 = B2
IF A1 + A2 = 2 THEN B2 = 2
IF A1 + A2 = 3 THEN B2 = 3
and so on
IF A1 + A2 = 10 THEN B2 = 1
IF A1 + A2 = 11 THEN B2 = 2
IF A1 + A2 = 12 THEN B2 = 3
IF A1 + A2 = 13 THEN B2 = 4
IF A1 + A2 = 14 THEN B2 = 5
IF A1 + A2 = 15 THEN B2 = 6
IF A1 + A2 = 16 THEN B2 = 7
IF A1 + A2 = 17 THEN B2 = 8
IF A1 + A2 = 18 THEN B2 = 9
IF A1 + A2 = 19 THEN B2 = 1
A1 and A2 must have a value between 1 and 9 otherwise ERROR!

I played with your suggestion but did not get any desired results. I need to
mention that I am new to Excel, so please if you can make it undaerstandable
for dummies.
Thanks a lot!
Tomas
"Peo Sjoblom" wrote:

One way just assuming since you done't say what should happen if C is less
than 10 or greater than 19

=IF(AND(C1<10,C119),"none",IF(C1=19,1,C1-9))

Regards,

Peo Sjoblom