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!

=ABS(A1)

or

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

or

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


Julie P. wrote:

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" wrote in message
...
=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!