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.

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.

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.

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.

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.

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.

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)

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.

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.