|
If Formula - Desperate for help
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... |
If Formula - Desperate for help
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 |
If Formula - Desperate for help
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. |
If Formula - Desperate for help
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 |
| All times are GMT +1. The time now is 11:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com