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 1place 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
Similar Questions

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 %? 
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 … 
Math
Number sense: Write the number that has 652 in the ones period and 739 in the thousands period. 
Health
What is the correct denominator for calculating the cesarean section rate? 
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 … 
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 
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 … 
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 
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 … 
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 …