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.

To create the formula in Excel 2003, you can follow these steps:

1. Start by typing "=" in the cell where you want the result of the formula to appear.

2. Next, enter the "IF" function by typing "IF(".

3. The first argument of the "IF" function is the logical test. In this case, you want to check if the Qtr Growth Rate (cell B10) is less than 0. So, you can enter "B10<0,".

4. For the second argument of the "IF" function, you want to calculate the revenue multiplied by either (Qtr Cost Rate + Extra) or just Qtr Cost Rate, based on the result of the logical test.

To calculate the first option, enter "B4*(B11+B12)," after the comma.

To calculate the second option, enter "B4*B11," after the comma.

5. Lastly, close the "IF" function by typing ")".

Your complete formula would look like this:

=IF(B10<0, B4*(B11+B12), B4*B11)

Make sure to double-check that the cell references (B10, B4, B11, B12) in the formula correspond to the correct cells in your Excel worksheet.