# 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

## 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

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