Computer Math

posted by Al

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

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

    devise a number system based on base 11. a)draw the number line b)show examples of addition and subtraction c)develop a representation of negative numbers based on elevens complement Hi Stephanie: I guess first I want to make sure …
  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. Maths

    A certain seven digit number has only ones in the ones period only threes in the thousands period and only twos in the lakhs period the number is?
  10. Math

    The generation time G for a particular bacterium is the time it takes for the population to double. The bacteria increase in population is shown by the formula G = t over 3.3log a p, where t is the time period of the population increase, …

More Similar Questions