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