A quick one

[jpowell79]

Can anyone tell me how I compare two cells (a1 and A2) , to see which one is farthest away from zero.....and then show the value as positive, in cell A3

for example

A1= 12
A2= -6

A3 would show 12


A1=8
A2=-23

A3 would show 23


A1= -14
A2= -8

A3 would show 14


a1= 52
a2=-32

A3 would show 52



Sure it's simple but can't quite work it out!

thanks guys

 

[agihcam]

in A3, type;

=MAX(ABS(A1),ABS(A2))