View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default 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.