Need to get rid of negative numbers

[dudoubleb]

Subtracting one column from another that sometimes results in a negative number....instead of a negative number i want the result displayed as 0.001

 

[p45cal]

=if(a1-b1<0,0.001,a1-b1)

 

[dudoubleb]

that worked perfect......and getting an answer in minutes, thats just tip top

 

[pgc01]

Hi

Another option:

=MAX(a1-b1,0.001)

 

[p45cal]

but not quite the same result if a1-b1 = anything between .001 and 0

 

[jasonb75]

A pointless alternative (but it works).

=--TEXT(A1-B1,"[<0]""0.001"";0.000")

 

[mgm05267]

Hi dudoubleb,

Simple....

"=ABS(A1-B1)"

Regards,

MGM

 

[p45cal]

Hi dudoubleb,

Simple....

"=ABS(A1-B1)"

Regards,

MGM

really?!

 

[Scott Huish]

ABS won't return .001 if it is a negative number.

Try 4 in A1 and 7 in B1.

 

[pgc01]

but not quite the same result if a1-b1 = anything between .001 and 0

You are right.

I assumed that since the OP wants negatives as 0.001 and not 0 that 0.001 was ok as a minimum value. I should, however, have written this.

Thanks for pointing it out.