View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.