| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting Negative Numbers to Positive
There has to be a way to do this other than multiplying by -1???
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Negative Numbers to Positive
=ABS(A1)?
-- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "bmmclen" wrote: There has to be a way to do this other than multiplying by -1??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Negative Numbers to Positive
check out ABS in help
"bmmclen" wrote: There has to be a way to do this other than multiplying by -1??? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Negative Numbers to Positive
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 In article , bmmclen wrote: There has to be a way to do this other than multiplying by -1??? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Negative Numbers to Positive
bmmclen wrote:
There has to be a way to do this other than multiplying by -1??? Cell A1 enter a negative No. in another cell enter =ABS(A1) Answer is positive No. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200702/1 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Negative Numbers to Positive
another thought occurs
=SQRT(A1*A1) "bmmclen" wrote: There has to be a way to do this other than multiplying by -1??? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Negative Numbers to Positive
How about
=IF(A1*A1=1,A1*A1,SQRT(A1*A1)) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Mike" wrote: another thought occurs =SQRT(A1*A1) "bmmclen" wrote: There has to be a way to do this other than multiplying by -1??? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Negative Numbers to Positive
=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 "Dave F" wrote: How about =IF(A1*A1=1,A1*A1,SQRT(A1*A1)) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Mike" wrote: another thought occurs =SQRT(A1*A1) "bmmclen" wrote: There has to be a way to do this other than multiplying by -1??? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Negative Numbers to Positive
Nice to see the minimilist method is the only solution
:) My answer to the original is Why, what's wrong with * (-1) ? Steve On Wed, 07 Feb 2007 15:17:00 -0000, Mike wrote: =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 "Dave F" wrote: How about =IF(A1*A1=1,A1*A1,SQRT(A1*A1)) Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Mike" wrote: another thought occurs =SQRT(A1*A1) "bmmclen" wrote: There has to be a way to do this other than multiplying by -1??? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Converting Negative Numbers to Positive
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change positive numbers to negative numbers without re-ente | Excel Worksheet Functions | |||
| converting hex values to negative numbers | Excel Discussion (Misc queries) | |||
| counting a string of negative or positive numbers | Excel Discussion (Misc queries) | |||
| formula for negative and positive numbers in different columns | Excel Worksheet Functions | |||
| Compare Negative & Positive Numbers | New Users to Excel | |||
Linear Mode
