B
bmmclen
There has to be a way to do this other than multiplying by -1???
D
Dave F
=ABS(A1)?
M
Mike
check out ABS in help
J
JE McGimpsey
Well, you could subtract the negative number from itself, then subtract
it again...
If you mean "a way to do this other than a formula", then one way:
Edit/Replace
Find what: -
Replace with: <leave blank>
it again...
If you mean "a way to do this other than a formula", then one way:
Edit/Replace
Find what: -
Replace with: <leave blank>
F
Francois via OfficeKB.com
bmmclen said:
Cell A1 enter a negative No.
in another cell enter =ABS(A1)
Answer is positive No.
M
Mike
another thought occurs
=SQRT(A1*A1)
=SQRT(A1*A1)
D
Dave F
How about
=IF(A1*A1=1,A1*A1,SQRT(A1*A1))
Dave
=IF(A1*A1=1,A1*A1,SQRT(A1*A1))
Dave
M
Mike
=MID(A1,MIN(IF(ISERROR(1*(MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1))),255,ROW(INDIRECT("A1:A"&LEN(A1))))),99)
entered as an array
entered as an array
S
SteveW
Nice to see the minimilist method is the only solution
My answer to the original is Why, what's wrong with * (-1) ?
Steve
My answer to the original is Why, what's wrong with * (-1) ?
Steve
A
Alan
.... 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
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