View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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.