Nested Forecast Formula Help
 

I'm looking to write a formula that matches two criteria before calculating a
forecast. I tried using a IF AND function but the Forecast function itself
will only calculate based on one X value. I want the X value only if it
returns a TRUE matching two criteria in two different columns first. Is there
a way to calculate this?

Here is my current forecast formula:
=FORECAST(F23,'Raw Data'!$G7:$G50003,'Raw Data'!$O7:$O50003)*F13

I want to do an IF(AND function first to match two values from two different
columns in my RAW Data worksheet. The problem is that the forecast formula
only looks for one value, but I want to qualify that value based on two
criteria that match first. I hope that is clear enough. Please let me know.
Thanks

Nested Forecast Formula Help
 

Do you mean that you want a sort of IF(A,F23,G23)?

--
__________________________________
HTH

Bob

"BBAL20" wrote in message
...
I'm looking to write a formula that matches two criteria before
calculating a
forecast. I tried using a IF AND function but the Forecast function itself
will only calculate based on one X value. I want the X value only if it
returns a TRUE matching two criteria in two different columns first. Is
there
a way to calculate this?

Here is my current forecast formula:
=FORECAST(F23,'Raw Data'!$G7:$G50003,'Raw Data'!$O7:$O50003)*F13

I want to do an IF(AND function first to match two values from two
different
columns in my RAW Data worksheet. The problem is that the forecast formula
only looks for one value, but I want to qualify that value based on two
criteria that match first. I hope that is clear enough. Please let me
know.
Thanks

Nested Forecast Formula Help
 

=IF(AND(F7='Raw Data'!C7:C50003,Calculator!F23='Raw
Data'!R7:R50003),FORECAST(F23,'Raw Data'!$G7:$G50003,'Raw
Data'!$O7:$O50003)*F13,"-")

Here is the formula I've been working on, but I can't get it to work. I want
to qualify to values to be true and then I want to forecast only the values
that meet the criteria in my If(And( stantement. Is there a way to make this
work. The forecast formula takes all values that are equal (F23) regardless
of the criteria. I only want the values that are tru for two criteria in two
seperate columns. I hope that helps.

"Bob Phillips" wrote:

Do you mean that you want a sort of IF(A,F23,G23)?

--
__________________________________
HTH

Bob

"BBAL20" wrote in message
...
I'm looking to write a formula that matches two criteria before
calculating a
forecast. I tried using a IF AND function but the Forecast function itself
will only calculate based on one X value. I want the X value only if it
returns a TRUE matching two criteria in two different columns first. Is
there
a way to calculate this?

Here is my current forecast formula:
=FORECAST(F23,'Raw Data'!$G7:$G50003,'Raw Data'!$O7:$O50003)*F13

I want to do an IF(AND function first to match two values from two
different
columns in my RAW Data worksheet. The problem is that the forecast formula
only looks for one value, but I want to qualify that value based on two
criteria that match first. I hope that is clear enough. Please let me
know.
Thanks