Sunday

December 21, 2014

December 21, 2014

Posted by **Al** on Friday, July 21, 2006 at 1:33pm.

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

**Answer this Question**

**Related Questions**

Help w/Quattro Formula - Am getting frustrated w/failing to get Quattro Pro ...

Statistics(Please help) - I have a chart that has 4 columns across the top and ...

english - choose an antonym from column 2. col 1 cure rejoice lucid stain,...

Computer pls help - A Harshad Number in a given number base is an integer that ...

heeeeeelp computer - A Harshad Number in a given number base is an integer that ...

Math - Number sense: Write the number that has 652 in the ones period and 739 in...

Health - What is the correct denominator for calculating the cesarean section ...

Computer science - If the last value of Period is less than the number of ...

maths - A certain nine digit number has only ones in ones period,only two’s in ...

Physics - Calculate the period of the wave if it makes 10 vibrations in 2 ...