hey all, how are you??I am desperately seeking a IF formula. Here is
the question that i am stuck at. I have 5 different fields for a
number of weeks, for eg. I have RAW SALES, FORECAST, PROMO FORECAST,
STORE FORECAST, OOS (Number of days out of stock). I currently have
the below formula :

if(and(OOS=0,Store Forecast=0,Promo Forecast=0),Raw sales, (Raw Sales/
7)*OOS + Raw Sales.

what i also need is, if either Store Forecast or Promo Forecast = 1, i
need the formula to equal the Raw Sales. How do i do this??Please
please please please help...love you all...

On Sun, 3 Aug 2008 05:22:58 -0700 (PDT), Gor_yee wrote:

hey all, how are you??I am desperately seeking a IF formula. Here is
the question that i am stuck at. I have 5 different fields for a
number of weeks, for eg. I have RAW SALES, FORECAST, PROMO FORECAST,
STORE FORECAST, OOS (Number of days out of stock). I currently have
the below formula :

if(and(OOS=0,Store Forecast=0,Promo Forecast=0),Raw sales, (Raw Sales/
7)*OOS + Raw Sales.

what i also need is, if either Store Forecast or Promo Forecast = 1, i
need the formula to equal the Raw Sales. How do i do this??Please
please please please help...love you all...


OR(and(OOS=0,Store Forecast=0,Promo Forecast=0),store forecast=1,promo
forecast=1)

--ron

On Aug 3, 10:39*pm, Ron Rosenfeld wrote:
On Sun, 3 Aug 2008 05:22:58 -0700 (PDT), Gor_yee wrote:
hey all, how are you??I am desperately seeking a IF formula. Here is
the question that i am stuck at. I have 5 different fields for a
number of weeks, for eg. I have RAW SALES, FORECAST, PROMO FORECAST,
STORE FORECAST, OOS (Number of days out of stock). I currently have
the below formula :

if(and(OOS=0,Store Forecast=0,Promo Forecast=0),Raw sales, (Raw Sales/
7)*OOS + Raw Sales.

what i also need is, if either Store Forecast or Promo Forecast = 1, i
need the formula to equal the Raw Sales. How do i do this??Please
please please please help...love you all...

OR(and(OOS=0,Store Forecast=0,Promo Forecast=0),store forecast=1,promo
forecast=1)

--ron

hi ron..

thanks for your prompt reply, but i dont really understand how this
formula works..i've tried entering it but it says the formula is wrong.

On Sun, 3 Aug 2008 05:58:51 -0700 (PDT), Gor_yee wrote:

On Aug 3, 10:39*pm, Ron Rosenfeld wrote:
On Sun, 3 Aug 2008 05:22:58 -0700 (PDT), Gor_yee wrote:
hey all, how are you??I am desperately seeking a IF formula. Here is
the question that i am stuck at. I have 5 different fields for a
number of weeks, for eg. I have RAW SALES, FORECAST, PROMO FORECAST,
STORE FORECAST, OOS (Number of days out of stock). I currently have
the below formula :

if(and(OOS=0,Store Forecast=0,Promo Forecast=0),Raw sales, (Raw Sales/
7)*OOS + Raw Sales.

what i also need is, if either Store Forecast or Promo Forecast = 1, i
need the formula to equal the Raw Sales. How do i do this??Please
please please please help...love you all...

OR(and(OOS=0,Store Forecast=0,Promo Forecast=0),store forecast=1,promo
forecast=1)

--ron

hi ron..

thanks for your prompt reply, but i dont really understand how this
formula works..i've tried entering it but it says the formula is wrong.

What I posted was a substitute for the logical test portion of your original
formula.

What, exactly did you enter?
Please do a Copy Paste into your newsreader.

--ron