Change value to a negative formula.

[NormanD85]

Is there a way to make a formula that if the result is greater than zero then it will change it to a negative number?

I want B3 to display J3, but if the result at J3 is greater then zero make it a negative number in B3.

 

[Joe4]

Welcome to the Board!

Try this:

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

or more simply:

=-ABS(B3)

 

[NormanD85]

Welcome to the Board!

Try this:

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

or more simply:

=-ABS(B3)

That works, Thank you. How do I get B3 to display the result from J3 if the result is less than zero?

 

[NormanD85]

Figured it out, Used =IF(OR(J3>0, J3<0),-J3,+J3) and it did what I was looking for it to do.

 

[Joe4]

That works, Thank you. How do I get B3 to display the result from J3 if the result is less than zero?

Figured it out, Used =IF(OR(J3>0, J3<0),-J3,+J3) and it did what I was looking for it to do.

If that formula really does what you want, it could be simplied to just this:

=-J3