# 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, 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.)

Al, the only spreadsheet I'm familiar with is Excel, so I don't know the syntax you're using. There should be a help icon on the toolbar to take questions and tell you how to enter a formula.

To Roger,
Would appreciate having the formula in Excel. I can handle it from there.
Thanks, Al

1. 👍 0
2. 👎 0
3. 👁 60

## Similar Questions

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

asked by Al on July 20, 2006

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
3. ### 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
4. ### Pyreenes Mountain Range

Are there are col fields a long the Pyrenees Mountain range?

asked by ♥rebel•stupidity=kathy♥ on April 10, 2012
5. ### Spanish homework

Please help me correct and properly translate the following Spanish paragraph: Ayer, vi a Martin Luther el sentarse encima de una calabaza grande. Una col cayó del cielo y lo golpeó en la cabeza. Martin Luther estaba enojado en

asked by Alex on April 12, 2008
6. ### statistics

Choose either 2 ¡Á 2 contingency table shown below (males or females). Research question: At ¦Á = .005, is smoking independent of race? (Smoking rates are from Statistical Abstract of the United States, 2001, pp. 16 and 12,

asked by ronald on March 13, 2012
7. ### Statistics

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 June 30, 2011
8. ### Statistics

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 June 30, 2011