Thread: -sign
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bbc1 bbc1 is offline
external usenet poster
 
Posts: 12
Default -sign

I have5 columns a b c d e
I would like a formula to work out and show a minus sign if the total of
cell d is greater than the total of cell a, if cell d is greater that cell a
just the difference,
ie a100 a10
d101 d 9
e -1 e 1