removing the "-" sign in a calucation

[gma]

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.

 

[Khoshravan]

Use Abs(number). This function returns the absolute value of the number.

 

[gma]

i'm sorry i dont understand do i write the formula like this:
=(A1*25%)-A1? or something different?

 

[smartin]

What you have:
=(A1*0.25)-A1

If you want this to always return a positive number:
=ABS((A1*0.25)-A1)

 

[John]

Hi
You can use it both ways, as per sample.
=ABS(0.935*25%-0.935) or =ABS(A1*25%-A1)
HTH
John

 

[Gord Dibben]

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

 

[JE McGimpsey]

Or, more succinctly:

=ABS(A1 * 0.75)

 

[gma]

thanks

What you have:
=(A1*0.25)-A1

If you want this to always return a positive number:
=ABS((A1*0.25)-A1)

 

[Khoshravan]

If you want to get positive value, you should enter =Abs((A1*25%)-A1)
Ex.: Abs(5)=5 and Abs(-5)=5