keep the results as positive numbers
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.
|