On Feb 7, 3:48 pm, SteveW wrote:

.... what's wrong with * (-1) ?

ABS(A1) or SQRT(A1*A1) will generate a positive result whether the
origininal number in A1 is +ve or -ve.

*(-1) only returns a +ve result if the value in A1 is -ve.

Regards,

Alan