View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Khoshravan Khoshravan is offline
external usenet poster
 
Posts: 211
Default 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.