Here is the problem I have. I have samples being collected and sent to a lab. When I receive the lab results it gets logged on this sheet in columns D and E. The formulas in columns F and H must use the results from the D and E entry for all the samples collected until it encounters another lab result, then the formula must use these results in D and E until yet another lab result is input. How do I get the formulas to see the new input and automatically change the formula for me.
formula : D E F
0.43 2.00 c18*d17*8.34
0 0 c19*d17*8.34
0 0 c20*d17*8.34
.51 1.11 c21*d20*8.34
0 0 c22*d20*8.34
Dont know if this is enough to go by, but you can see that when it encounters a new lab results the formula must change.
Any help will be great.
formula for this problem
alphonso
Hi
A simple way of doing this is to add two extra columns (M & N say), then use these in the formulas in columns F & H rather than D & E.
Row x of column M should then contain something like ...
=IF(Dx<>0,Dx,Mx-1)
The formulas for column N should be similar. This says if column D is not zero use this otherwise use the value above. You do have to have a slightly different formula in the first row because there is no previous row with a value in it.
Regards
PeterMo.