Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing the "-" sign in a calucation
when i doing a calucation, =.933 x 25% = .233 minus .933 i get a minus sign
in front of the result. how can i do the calucation and remove the "-" sign? this is throwing all the other cells off. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing the "-" sign in a calucation
Use Abs(number). This function returns the absolute value of the number.
"gma" wrote: when i doing a calucation, =.933 x 25% = .233 minus .933 i get a minus sign in front of the result. how can i do the calucation and remove the "-" sign? this is throwing all the other cells off. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing the "-" sign in a calucation
i'm sorry i dont understand do i write the formula like this:
=(A1*25%)-A1? or something different? "gma" wrote: when i doing a calucation, =.933 x 25% = .233 minus .933 i get a minus sign in front of the result. how can i do the calucation and remove the "-" sign? this is throwing all the other cells off. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing the "-" sign in a calucation
What you have:
=(A1*0.25)-A1 If you want this to always return a positive number: =ABS((A1*0.25)-A1) gma wrote: i'm sorry i dont understand do i write the formula like this: =(A1*25%)-A1? or something different? "gma" wrote: when i doing a calucation, =.933 x 25% = .233 minus .933 i get a minus sign in front of the result. how can i do the calucation and remove the "-" sign? this is throwing all the other cells off. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing the "-" sign in a calucation
Hi
You can use it both ways, as per sample. =ABS(0.935*25%-0.935) or =ABS(A1*25%-A1) HTH John "gma" wrote in message ... i'm sorry i dont understand do i write the formula like this: =(A1*25%)-A1? or something different? "gma" wrote: when i doing a calucation, =.933 x 25% = .233 minus .933 i get a minus sign in front of the result. how can i do the calucation and remove the "-" sign? this is throwing all the other cells off. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing the "-" sign in a calucation
Your operations return a negative number
How do the other cells get "thrown off"? You can turn to positive by using ABS function but will that give you correct results? Gord Dibben MS Excel MVP On Mon, 2 Feb 2009 14:35:01 -0800, gma wrote: when i doing a calucation, =.933 x 25% = .233 minus .933 i get a minus sign in front of the result. how can i do the calucation and remove the "-" sign? this is throwing all the other cells off. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing the "-" sign in a calucation
Or, more succinctly:
=ABS(A1 * 0.75) In article , smartin wrote: If you want this to always return a positive number: =ABS((A1*0.25)-A1) |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing the "-" sign in a calucation
thanks
"smartin" wrote: What you have: =(A1*0.25)-A1 If you want this to always return a positive number: =ABS((A1*0.25)-A1) gma wrote: i'm sorry i dont understand do i write the formula like this: =(A1*25%)-A1? or something different? "gma" wrote: when i doing a calucation, =.933 x 25% = .233 minus .933 i get a minus sign in front of the result. how can i do the calucation and remove the "-" sign? this is throwing all the other cells off. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing the "-" sign in a calucation
If you want to get positive value, you should enter =Abs((A1*25%)-A1)
Ex.: Abs(5)=5 and Abs(-5)=5 "gma" wrote: i'm sorry i dont understand do i write the formula like this: =(A1*25%)-A1? or something different? "gma" wrote: when i doing a calucation, =.933 x 25% = .233 minus .933 i get a minus sign in front of the result. how can i do the calucation and remove the "-" sign? this is throwing all the other cells off. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to "sign" macro with "digital certificate"? | New Users to Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |