Computer Math

posted by .

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

Respond to this Question

First Name
School Subject
Your Answer

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 %?
  2. chemistry

    what is the difference between elements in a group and elements in a period on the periodic table Elements in the same group have similar chemical properties. Element in the same period have properties that change periodically across …
  3. Math

    Number sense: Write the number that has 652 in the ones period and 739 in the thousands period.
  4. Health

    What is the correct denominator for calculating the cesarean section rate?
  5. Computer science

    If the last value of Period is less than the number of periods specified in the Parameters worksheet, increment the Period value by 1, otherwise blank the cell(i.e. ""). What does this mean in spreadsheer syntax for excel using the …
  6. 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
  7. 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 need …
  8. maths

    A certain nine digit number has only ones in ones period,only two’s in the thousand period and only threes in millions period .Write this number in words in the Indian system
  9. heeeeeelp computer

    A Harshad Number in a given number base is an integer that is divisible by the sum of its digits when written in that base. For example, the number 11 in base 5 (which is 6 in base 10) is divisible by 1 + 1 = 2 in base 5. It is therefore …
  10. Computer pls help

    A Harshad Number in a given number base is an integer that is divisible by the sum of its digits when written in that base. For example, the number 11 in base 5 (which is 6 in base 10) is divisible by 1 + 1 = 2 in base 5. It is therefore …

More Similar Questions