View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aggies Aggies is offline
external usenet poster
 
Posts: 9
Default Insert symbol in front of value

I have a basic formula of =Sum(J2-I2) for an entire column and I am needing a
specific format.

If the sum equals a value greater than the value in cell J2 place a + sumbol
in front of that value.

I hope I am making sense. Please help..
2-3=+1
--
Thank you for your time.
"Happiness is not having what you want, but wanting what you have"