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

Similar Questions
    1. answers icon 0 answers
    1. answers icon 1 answer
  1. Find the representation of the number 256 in the following bases:a. base six b. base twelve c. base two I get how to write the
    1. answers icon 2 answers
  2. Which is true of a period in the periodic table?A. Atomic numbers increase from left to right across each period. B. Elements in
    1. answers icon 0 answers
more similar questions