Nested Forecast Formula Help

  • Thread starter Thread starter BBAL20
  • Start date Start date
B

BBAL20

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
 
=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.
 
Back
Top