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

    Are there are col fields a long the Pyrenees Mountain range?
  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
  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,
  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
  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
  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
  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

More Similar Questions