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]

Or
15/3=8.33

We need to understand how you are arriving at these numbers? If you want us to help you.

 

[leecavturbo]

divide by 3. because 3 cells. start cell end cell and empty cell

 

[leecavturbo]

5+10/3 = 8.33

 

[gaz_chops]

divide by 3. because 3 cells. start cell end cell and empty cell

So how does 15/3=8.33?

 

[gaz_chops]

5+10/3 = 8.33

That just doesn't make sense, you are taking an average of 10/3 then adding 5!!

 

[V_Malkoti]

How does 4/3=2?

I think its 1 + 3/3 and 5 + 10/3 but that's not average

 

[leecavturbo]

hang on wasn't engaging brain but just punching in calculator (app on phone) and 5+10/3=8.33 but 10+5/3=11.66

 

[gaz_chops]

hang on wasn't engaging brain but just punching in calculator (app on phone) and 5+10/3=8.33 but 10+5/3=11.66

10+5=15
15/2=7.5 (Average)

 

[leecavturbo]

ok yeah that's linear.
how do we make it work with a start and end value with a number of cells in between.
all we know is the start value , end value, number of empty cells to populate

 

[leecavturbo]

5
15.125
25.25
35.375
45.5
55.625
65.75
81

I came to the above by typing in formula and dragging down but I had to manually count the number of cells. need to automate it
=A1+A$8/8