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

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

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