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.

  1. 👍 0
  2. 👎 0
  3. 👁 117
asked by Dee

Respond to this Question

First Name

Your Response

Similar Questions

  1. Algebra II Help

    4) The function f(x)=2(3)^x represents the growth of a dragonfly population every year in a remote swamp. Rose wants to manipulate the formula to an equivalent form that calculates seven times a year, not just once a year. Which

    asked by Anonymous on May 12, 2017
  2. Math

    N(t)=2000e^(1.1t) the continuous growth rate is 110% effective growth rate?__% Q(t)=65e^(0.09t) continuous growth rate is 9% effective growth rate?__% G(t)=650e^(0.055t) continuous growth rate is 5.5% effective growth rate?__%

    asked by Evenlyn on April 9, 2017
  3. Accounting

    Genentech, Inc. is a California-based biotech pioneer recently acquired by Swiss pharmaceutical giant Roche Holding AG. Roche paid $46.8 billion in cash for the 44 percent of Genentech it did not already own, implying a market

    asked by Joy on November 2, 2013
  4. Algebra - Can you PLEASE check - I"m stuck!

    Bob is studying the growth of a particular species of plant. He writes the following equation to show the height of the plant f(n), in cm, after n days: F(N)=10(1.02)^n 1. Starting from 0 days, plug x-values into our function to

    asked by Jake on November 17, 2014
  5. Accounting

    How can I find the supernormal growth rate and constant growth rate of a stock? V = D1/k-g V = the value of the stock D1 = the dividend next period k = the required rate of return g = constant growth rate I'm confused on how to

    asked by Lyra on June 27, 2017
  6. Math

    What is the value of a stock that grows at a supernormal rate of 18% for the first four years, and then slows down to a constant growth rate of 10%? An annual dividend of $2.00/share was just paid, and the rate of return on common

    asked by Lyra on June 23, 2017
  7. Pre Calc

    Use the doubling time to find the continuous percent growth rate and give a formula for the function. Round your answer to two decimal places. I found the doubling time to be 24 days and the continuous percent growth rate to be

    asked by Taylpr on October 3, 2014
  8. Computer - Excel Mail Merge

    I have a problem when doing the mail merge with Office 2003. First of all, I wrote a letter in Word 2003 and then try to merge some data from Excel 2003. The data in Excel column was listed as below: A1=101 A2=123 A3=134 A4=148A

    asked by Lamp on July 4, 2008
  9. college algebra

    23. In biology, the function defined by g(x)=5x/2+x gives the growth rate of a population for x units of available food. (Source: Smith, J. Maynard, Models in Ecology, Cambridge University Press.) (a) What amount of food (in

    asked by Anonymous on May 29, 2017
  10. Math

    Write the exponential function y=6(1.21)t in the form y=aekt. (a) Once you have rewritten the formula, give k accurate to at least four decimal places. k= help (numbers) If t is measured in years, indicate whether the exponential

    asked by ann on March 15, 2016

More Similar Questions