A quick question about subtraction

[MrsFrankieH]

Hello everyone.

My computer is Dell and I'm working with Office 10.

I'd like to know how I can use a formula to subtract a larger number from a smaller one without creating a negative.

For example:

[TABLE="width: 256"]
<tbody>[TR]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD][TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]16
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]16
[/TD]
[TD="align: center"]16
[/TD]
[/TR]
[TR]
[TD="align: center"]29
[/TD]
[TD="align: center"]31
[/TD]
[TD="align: center"]65
[/TD]
[TD="align: center"]67
[/TD]
[/TR]
[TR]
[TD="align: center"]-13
[/TD]
[TD="align: center"]-15
[/TD]
[TD="align: center"]-49
[/TD]
[TD="align: center"]-51[/TD]
[/TR]
</tbody>[/TABLE]

Thank you for any help in advance
<strike></strike>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

 

[footoo]

Perhaps : =ABS(16-29)

 

[Nishant94]

=abs(a2-a1)

 

[MrsFrankieH]

Perhaps : =ABS(16-29)

Thank you Footoo, I'll give it try! Thanks again!!

 

[MrsFrankieH]

=abs(a2-a1)

Thank you Nishant94!! I'll give this a try also! It's always better when there is more than one way.

Thanks again!

 

[footoo]

Thank you Nishant94!! I'll give this a try also! It's always better when there is more than one way.

Thanks again!

It's the same way.

 

[MrsFrankieH]

It worked!! Thank you!!!

 

[MrsFrankieH]

Thank you so very much. It worked!! Have a great night!

 

[MrsFrankieH]

It worked, thank you for your help. There are two of you in the thread and it's my desire to thank you both. Thank you Footoo and Nishant94!