IF statement with change to data

[JTL9161]

I am trying to write a IF statement.

IF A1 is less than 0 THEN show A1 as a positive, but if A1=BLANK , then show A2 as a positive. Either A1 or A2 will be a negitive. Which ever of the 2 cells has the negative I want to show that number as a positive.

Thanks
James

 

[Coyotex3]

You can show the number on A1 as positive by putting the following on A2

=ABS(A1)

But you need the absolute value to be reflected on A1?

 

[JTL9161]

Forgot about ABS. That works thanks.