View Single Post
  #2   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

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.