View Single Post
  #1   Report Post  
Jambruins
 
Posts: n/a
Default Finding middle value

I have numbers in cells J3:J61 and L3:L61. Some are positive and some are
negative. I would like cells K3:K61 to find the middle value between the
corresponding J and L cells. For example
cell J61 is -185
cell L61 is +113
I would like cell K61 to be +136.

Once a positive number goes down to +100 it would then go to -101 instead of
99. How would I do this? Thanks