average fill

[leecavturbo]

if I have value 1 in A1 and value 4 in A4; A2 should equal 2 and A3 should equal 3.

 

[gaz_chops]

Why?

 

[leecavturbo]

Gaz

I need the cells in between 2 values to fill with the average

i.e
350
403
670
970
1265

 

[gaz_chops]

Sorry I still don't follow, how do you get 403, 670 etc?

 

[V_Malkoti]

Why?

I have tears in my eyes.

350
403
670
970
1265

Lee can you explain how you got those three values in between?

 

[gaz_chops]

I have tears in my eyes.

I couldn't resist

 

[leecavturbo]

I made them up lol.

someone must get me

 

[gaz_chops]

I made them up lol.

someone must get me

Explain how, then we might be able to help.

 

[leecavturbo]

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

 

[gaz_chops]

How does 4/3=2?