Prev: If formula current/expired/blank
Next: Countif Help
From: Corey on 1 Mar 2010 00:11
I have a chart on a worksheet, that is created by data in another worksheet.

Basically the chart will be an area chart with readings that will decrease
in value after easch test date.

eg.

A B C D
E F G

1/1/2010 | 6.25 | 6.24 | 6.24
| 6.25 | 6.25 | 6.26 |
--------------------------------------------------------------------------------------------------------------
1/2/2010 | 6.23 | 6.22 | 6.22
| 6.23 | 6.21 | 6.24 |
--------------------------------------------------------------------------------------------------------------
1/3/2010 | 6.21 | 6.20 | 6.19
| 6.17 | 6.18 | 6.23 |
--------------------------------------------------------------------------------------------------------------
1/4/2010 | 6.19 | 6.17 | 6.14
| 6.14 | 6.17 | 6.21 |

etc....

What i want to do is have a cell value(say H10) set as the MINIMUM
reading(say 1.00), and then have another cell value with a formula to
give an estimated date(A) that based on the descreasing flow of values each
column value will reach the MINIMUM value?

So there may need to be (as in this case - 6 formula's) to display a
projected Date when the value at the current rate of decrease will reach the
MINIMUM set value.


How would i go about this?


Corey....


 | 
Pages: 1
Prev: If formula current/expired/blank
Next: Countif Help