View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
s7out s7out is offline
external usenet poster
 
Posts: 2
Default Help with this formula

I need a cell to equal another cell but flip it's "-" value to a "+" and to show it. In other words cell B2 = "-6.5". I need cell H2 to read "+6.5" (with the "+" visable. I normally would have this cell = '+6.5 however since this is a formula I don't know how to achieve the same result. Please advise. Thanks!