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