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)


"Ron Coderre" wrote in message
...
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


"Raza" wrote:

Thanks Ron, I forgot about the absolute value function

"Ron Coderre" wrote:

Try something like this:

=ABS(H2-B2)

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

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

XL2002, WinXP


"Raza" wrote:

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.