Help w/Quattro Formula

Am getting frustrated w/failing to get Quattro Pro formula right. Here's what I'm looking for:

Col. A = Base period number
Col. B = Given number this current period.

Formula I need:

If B >= A, what is %? (Example: A=20, B=30, the # I want should read 50.0, not 1.5)

Further, If B < A, what is the negative percentage, shown as a 1-place number w/a minus sign AND shown in Red. (Example: A = 40, B = 30. The result should appear as -25.0 in red, and not 0.75.)

I'd sure appreciate your help. Thanks.

asked by Al

Respond to this Question

First Name

Your Response

Similar Questions

  1. Computer Math

    Can anyone help me? Here's what I'm looking for: Col. A = Base period number Col. B = Given number this current period. NEEDED: Spreadsheet formula for: If B >= A, what is %? (Example: A=20, B=30, the # I want should read 50.0,
  2. Statistics(Please help)

    I have a chart that has 4 columns across the top and 33 going down. The colunms on the top read: predicted number, selected number, (col 1 - col2)^2, and the mean of x. Their are 32 predicted numbers and 33 selected numbers. I
  3. Chemistry

    If you divide the molar mass of a compound by the empirical formula mass, what is the result? That division should be VERY close to a whole number. Usually, 0.9 to 1.1 or 1.9 to 2.1 (all depending upon the accuracy and precision
  4. Physics

    I'm haivng troulbe proving the deriviation of this formula on my own... could you please help me derive the proof of the formula or maybe show me one thansk... I need to prove this formula period of a mass spring system in simple
  5. precal

    You can find the size of a population after t years using the formula N = No(1 + r)^t where No is the initial size of the population, N is the final size of the population, r is the rate of growth or decay per time period, and t
  6. Physics

    Calculate the period of the wave if it makes 10 vibrations in 2 seconds. Does anyone know the formula for this? frequency = (number of waves) divided by(observation time) = 10/2 = 5 Hertz period = 1/frequency = ?
  7. Physics

    I got part a but I'm having trouble figuring out b... I know the formula should be something like: T=2pi/omega and omega=sqrt(k/m) but how am I supposed to find T when I don't know k or m?? A pendulum has a period of 2.4 s. a)
  8. Algebra

    The formula T=2π√L/480 can be used to find the period (T in seconds, the time it takes a pendulum to complete one cycle) of a pendulum that is L cm long. (a)Rewrite this formula using rational exponents. Don't forget to
  9. PHYSiCS --

    A pendulum makes 120 complete oscillations in 3.00 minutes at a location where g= 9.98m/s^2 Find the period of the period Find the length I tried using the 2pi sqrt. L/g formula I don't know why I got this huge number
  10. Math

    Mathematicians have been searching for a formula that yields prime numbers. One such formula was x2 - x+41. Select some numbers for x, substitute them in the formula,and see if prime numbers occur. Try to find a number for x that

More Similar Questions