sukhoi35
asked on
Find max absolute of two numbers and retain it's original sign.
Experts,
I am trying to find the absolute highest value of two columns and store it in the third column. The only catch here is the value stored in the third column should retain it's original sign.
For example, for the values -0.1430000060 and -0.1410000030 when I run =MAX(ABS(A1:B1)), it returns 0.1430000060 without the - sign. Any suggestions?
Sample.xlsx
I am trying to find the absolute highest value of two columns and store it in the third column. The only catch here is the value stored in the third column should retain it's original sign.
For example, for the values -0.1430000060 and -0.1410000030 when I run =MAX(ABS(A1:B1)), it returns 0.1430000060 without the - sign. Any suggestions?
Sample.xlsx
ASKER
The numbers can be either positive or negative. Sorry, the sample I chose contains only negative, it is a pretty huge file running into several hundred thousands of rows.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, Wayne!
=MIN(A1:B1)