keep the results as positive numbers

[Guest]

I am subtracting the actual daily high from the predicted daily high
temperature.

My formula is this:
=H2-B2

However, I want my results to always be positive numbers. I feel like there
should be a simple mathematical answer, but I didn't pay attention very well
at school.

Thanks.

 

[Guest]

Try something like this:

=ABS(H2-B2)

Or...maybe
=MAX(H2-B2)-MIN(H2-B2)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Gord Dibben]

Raza

=ABS(H2-B2)


Gord Dibben MS Excel MVP

 

[Guest]

Thanks Ron, I forgot about the absolute value function

 

[Guest]

You're very welcome, Raza....and thanks for the feedback!

by the way...
my 2nd formula should have been
=MAX(H2:B2)-MIN(H2:B2)

instead of
=MAX(H2-B2)-MIN(H2-B2)

(I forgot to replace minus signs when I copied your formula)
***********
Regards,
Ron

XL2002, WinXP

 

[Chip Pearson]

my 2nd formula should have been

=MAX(H2:B2)-MIN(H2:B2)

I hate to tell you this, Ron, but your revised formula is still wrong. You
want

=MAX(H2,B2)-MIN(H2,B2)

Comas, not colons.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Guest]

Ya know, Chip.....if I drank, I'd have an excuse...but, I don't.

Thanks for catching that.

***********
Best Regards,
Ron

XL2002, WinXP