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:

16 16 16 16 29 31 65 67 -13 -15 -49 -51 <tbody> </tbody> Thank you for any help in advance <strike></strike> <tbody> </tbody>

<tbody>
</tbody>

 

[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!