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 