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 %? 
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 … 
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 
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? 
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, …