If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with formula
I have data readings on a worksheet in cells B3:AF12 (10 rows deep x 31
columns wide). I also have a date in cells A3:A12. One date for each row of data that was taken. I have the following formulas set up in order to forecast, when a designated Minimum value is to be reached. The below is the formula's i am using to forecast when the value set in A15 will be reached for each individual column of data. The result is displayed as a date, calculated from the list of dats in Column A.. B16=FORECAST(A15,A3:A12,B3:B12) ..... ..AF16=FORECAST(A15,A3:A12,AF3:AF12) A16 - basically formulates the lowest(min) reading across the data in row 16, and displays the date when this forecast data will reach the set value in A15. A16=IFERROR(MIN(B16:AF16),"") However, rather than just relying on the Single most Lowest reading to Forecast, i want to set a percentage of data values to set the Forecast data. eg. Instead of the lowest reading being forecast by a date, i want say the date forecast to be when 10% of the reading will reach that amount. How would i go about changing the single MIN value to a set Percentage(say 10%) instead? Corey.... |
Thread Tools | |
Display Modes | |
|
|