leecavturbo
Well-known Member
- Joined
- Jan 4, 2008
- Messages
- 681
if I have value 1 in A1 and value 4 in A4; A2 should equal 2 and A3 should equal 3.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
average fill
- Thread starter leecavturbo
- Start date
leecavturbo
Well-known Member
- Joined
- Jan 4, 2008
- Messages
- 681
Gaz
I need the cells in between 2 values to fill with the average
i.e
350
403
670
970
1265
I need the cells in between 2 values to fill with the average
i.e
350
403
670
970
1265
Upvote
0
Upvote
0
leecavturbo
Well-known Member
- Joined
- Jan 4, 2008
- Messages
- 681
I made them up lol.
someone must get me
someone must get me
Upvote
0
Explain how, then we might be able to help.
Upvote
0
leecavturbo
Well-known Member
- Joined
- Jan 4, 2008
- Messages
- 681
I just need the average of the cells either side of a cell or range cells
a1 = 1
a2 = a1+a3/number of cells
a3 = 3
answer in a2 should equal 2
or
a1 = 5
a2 = a1+a3/number of cells
a3 = 10
answer in a2 should equal 8.33
a1 = 1
a2 = a1+a3/number of cells
a3 = 3
answer in a2 should equal 2
or
a1 = 5
a2 = a1+a3/number of cells
a3 = 10
answer in a2 should equal 8.33
Last edited:
Upvote
0
Similar threads
- Question
