| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding min and max date of a given month | Excel Worksheet Functions | |||
| finding the second largest number in a list | Excel Discussion (Misc queries) | |||
| Finding Median if a value = 1.. help! | Excel Worksheet Functions | |||
| Finding Cell References | Excel Discussion (Misc queries) | |||
| How can i imput a formula in excel for finding the area of a regu. | Excel Discussion (Misc queries) | |||
Threaded Mode
