My formula won't work

[Julie P.]

Hi, sorry for another post, but my formula is not working:

=IF(A1=positive,A1,-A1)

I want to take any negative value and make it positive, but leave positive
values alone. I have tried "pos" and "+" as well, but those did not work
either.

Thanks for any help!

 

[garfield-n-odie]

=ABS(A1)

or

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

or

=IF(A1>=0,A1,-A1)

 

[Julie P.]

=ABS(A1)

or

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

or

=IF(A1>=0,A1,-A1)

Oh, duh! I should have thought of the greater and less than symbols!

Thanks Garfield!