Help w/Quattro Formula

posted by .

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.

Respond to this Question

First Name
School Subject
Your Answer

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 %?
  2. Physics

    Calculate the period of the wave if it makes 10 vibrations in 2 seconds. Does anyone know the formula for this?
  3. Chemistry

    If you divide the molar mass of a compound by the empirical formula mass, what is the result?
  4. math

    In the formula s=ut+1/2at square.Make a the subject of formula (b)find the values ot t when s=42,u=2 and a=8.Am getting difficulties in that number.
  5. Algebra

    I have two problems that I am not sure about how to work out. 1. The distance traveled by a falling object is given by the formula d=4.9t^2, where d is in meters and t is in seconds. Solve the formula for t. 2.The volume of a right …
  6. ALGEBRA

    I have two problems that I am not sure about how to work out. 1. The distance traveled by a falling object is given by the formula d=4.9t^2, where d is in meters and t is in seconds. Solve the formula for t. 2.The volume of a right …
  7. 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 harmonic …
  8. trig

    list the period, amplitude, interval, and phase shift of: g(t)=5/2sint-pi i know the amplitude is 5/2 but everything else im not getting. the regular formula for these is y=Asin(Bx+C)+D A is the amplitude B is the period which you …
  9. 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 is …
  10. 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 need …

More Similar Questions