Re: Nested Forecast Formula Help by BBAL20
BBAL20
Thu Jul 24 12:07:00 CDT 2008
=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" <BBAL20@discussions.microsoft.com> wrote in message
> news:1BEEC2A8-DBD2-4EAC-BE6B-E5ED81B59232@microsoft.com...
> > 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
> >
> >
>
>
>