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.

  1. 👍 0
  2. 👎 0
  3. 👁 90
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,

    asked by Al on July 21, 2006
  2. Genetics

    Need help figure out the order of GENES. Okey here is the info Bacterial cells of genotype pur- pro+ his+ were transduce with P1 bacteriophage grown on bacteria of genotype pur+ pro- his-. Transductants containing pur+ were

    asked by Amphee on December 9, 2010
  3. History

    from Miranda v. Arizona What does Chief Justice Warren state is the primary fault of officers in the cases under consideration? failing to let suspects make phone calls failing to get written confessions failing to ensure

    asked by Brianna on October 8, 2018
  4. english

    choose an antonym from column 2. col 1 cure rejoice lucid stain,pollute slack abhor enjoyable reowned boasting freed col 2 taut relish purge loathsome lament affliction cowering fetter infamous murky

    asked by ashley on September 8, 2009
  5. 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

    asked by Hannah on July 2, 2011
  6. Grammar (will you check the rest please)

    Demonstrative Pronoun or Adjective? 1. Does anyone know how to bake this cake? ADJ 2. You can check that book out of the library tomorrow. ADJ 3. That singer is ainger is quite talented. ADJ 4. Those do not heat as well as some.

    asked by Tiffany on March 24, 2010
  7. HS English

    VERB ADJ NOUN PRO VERB PHRASE Identify the poem you will analyze, CONJ VERB PRO VERB PRO and explain why you chose it.

    asked by Shelley on November 3, 2015
  8. math - probability

    Imagine a LONG bike with a total of 4 wheels - 2 in the front and 2 in the back. For the bike to work at all, at least 1 front wheel and 1 back wheel must be operational. All 4 tires are the same and each, individually, has

    asked by andrew on November 3, 2006
  9. math

    The table below gives the total spectator attendance for various U.S. sports in 1997. Sport Attendance (millions) Pro Baseball 64.9 College Basketball (Men’s) 27.7 College Basketball (Women’s) 6.7 Pro Basketball (Men’s) 21.7

    asked by Please help me!!!!! on September 4, 2011
  10. academic execellence

    Which of the following is NOT a potential consequence of plagiarism? A. Academic warning B. Academic probation C. Failing the course D. Cancellation of the program Is the answer C..failing the course?

    asked by michelle on January 22, 2014

More Similar Questions