If Formula - Desperate for help

  • Thread starter Thread starter Gor_yee
  • Start date Start date
G

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...
 
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...
Click to expand...


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

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

--ron
Click to expand...

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.
 
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.
Click to expand...

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