Forecast Formula Help

B

BBAL20

I'm looking to write a formula that matches two criteria before calcualting 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?
 
D

David Biddulph

What IF AND formula did you try?
What two criteria do you want to meet?
What FORECAST function are you trying to evaluate?
 

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

Similar Threads

Nested Forecast Formula Help 2
Transfer data between two tables 3
Forecast Formula help 5
COMPLICATED FORMULA WITH EMBEDDED HLOOKUP 2
How to concatenate text into a formula? 5
Entering an "IF" formula 10
Forecast with two unknown variables 4
formula for a cell changes over time 0

Top