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

Please help. Thanks.


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
asked by Al

Respond to this Question

First Name

Your Response

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

    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
  9. Statistics(Urgent!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 1, 2011
  10. U.S History

    Unscramble this message : The or mph die triu col bmit onie the ow c r su itdhe s mu ast st e is n Hi Anonymous - "The die is now cast. The colonies must either submit or triumph." Bonus: It was said by George III as a reaction to

    asked by Anonymous on October 4, 2006

More Similar Questions