How do you get rid of negative numbers?

**trowell** · 08-26-2011, 04:47 AM

How do you format cells with a formula so that if the number is negative it will be positive and if number is positive still positive

Thanks

**WinteE** · 08-26-2011, 04:49 AM

Changing the format is not enough, use =ABS(-250) to get 250.

**trowell** · 08-26-2011, 04:57 AM

Thanks

What does the IF function mean?

**arthurbr** · 08-26-2011, 05:24 AM

XL provides assistance on functions and much more - Press F1 and you are on.

**royUK** · 08-26-2011, 08:00 AM

You can multiply by -1

=IF(A1<0,A1*-1,A1)

Re: How do you get rid of negative numbers?