R
Rich
I am working on a worksheet that has 2 columns of data (times). I am using
the data to calculate slope and intercept to predict other outcomes. Some of
the cells are empty. Is there a way to setup the formulas I am using so that
it will ignore the empty cells?
Ex: ( _ means empty)
_ _
_ _
0:06:03 0:06:03
_ _
0:12:55 0:06:28
0:20:39 0:06:39
_ _
_ _
0:42:50 0:06:54
_ _
_ _
_ _
1:30:00 0:07:14
My one formula I am using is:
=(SLOPE($C$8:$C$12,LN($B$8:$B$12))*(LN(0.005556)))+INTERCEPT($C$8:$C$12,LN($B$8:$B$12))
which works fine and evaluates correct when the data has no empty cells.
Thanks
Rich
the data to calculate slope and intercept to predict other outcomes. Some of
the cells are empty. Is there a way to setup the formulas I am using so that
it will ignore the empty cells?
Ex: ( _ means empty)
_ _
_ _
0:06:03 0:06:03
_ _
0:12:55 0:06:28
0:20:39 0:06:39
_ _
_ _
0:42:50 0:06:54
_ _
_ _
_ _
1:30:00 0:07:14
My one formula I am using is:
=(SLOPE($C$8:$C$12,LN($B$8:$B$12))*(LN(0.005556)))+INTERCEPT($C$8:$C$12,LN($B$8:$B$12))
which works fine and evaluates correct when the data has no empty cells.
Thanks
Rich