hi,
The question is not clear.
Supposing A1=097,A2=111, 097-111 gives -14.
If you mean that if the result is negative, add 1000 to that,then a formula
can be arrived as
=if(A1-A2<0,A1-A2,A1-A2+1000)
Thank you,
K.S.Warrier


"Viper5963" wrote:

I am trying to take a number like 097, subtract 111. I don't want my new
number to become -186, instead I want 986. I am trying to use an IF
statement that looks like this:

=IF(LEFT(A1)
="0","9",LEFT(A1)-1&IF(MID(A1,2,1)="0","9",MID(A1,2,1)-1&IF(RIGHT(A1)="0","9",RIGHT((A1)-1))))

This works fine for the first number, but if I enter new numbers in the
column and copy the formula down, I get invalid data . Please help