posted by Dee .
I am trying to do a formula/function in excel 2003 for this:
IF(Qtr Growth Rate<0, Revenue*(Qtr Cost Rate + Extra), Revenue*Qtr Cost Rate)
Qtr Growth Rate is B10
Revenue is B4
Qtr Cost Rate is B11
Extra is B12
I keep coming up with the wrong total and this is where I think I am going wrong.