Oprichnick
Board Regular
- Joined
- May 30, 2013
- Messages
- 69
Hy all,
I'm trying to use a Forecast function in which I just want to use the non blank cells. The formula:
=FORECAST($QG$7;IF(PW8:QF8<>0;PW8:QF8);IF(PW8:QF8<>0;$PW$7:$QF$7))
In the second block of the Forecast function "IF(PW8:QF8<>0;PW8:QF8)" it returns only the non blank cells;
However in the third block "IF(PW8:QF8<>0;$PW$7:$QF$7)" it returns me all x values.
I want to use only the X values to which there are Y values.
Thanks in advance,
Pedro
I'm trying to use a Forecast function in which I just want to use the non blank cells. The formula:
=FORECAST($QG$7;IF(PW8:QF8<>0;PW8:QF8);IF(PW8:QF8<>0;$PW$7:$QF$7))
In the second block of the Forecast function "IF(PW8:QF8<>0;PW8:QF8)" it returns only the non blank cells;
However in the third block "IF(PW8:QF8<>0;$PW$7:$QF$7)" it returns me all x values.
I want to use only the X values to which there are Y values.
Thanks in advance,
Pedro