Nested Forecast Formula Help

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
 
B

BBAL20

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top