If Formula - Desperate for help

[Gor_yee]

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

 

[Ron Rosenfeld]

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

 

[Gor_yee]

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.

 

[Ron Rosenfeld]

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