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 %? (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.)
I'd sure appreciate your help. Thanks.
asked by
Al
Respond to this Question
Similar Questions

Computer Math
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, 
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 
Chemistry
If you divide the molar mass of a compound by the empirical formula mass, what is the result? That division should be VERY close to a whole number. Usually, 0.9 to 1.1 or 1.9 to 2.1 (all depending upon the accuracy and precision 
Physics
I'm haivng troulbe proving the deriviation of this formula on my own... could you please help me derive the proof of the formula or maybe show me one thansk... I need to prove this formula period of a mass spring system in simple 
precal
You can find the size of a population after t years using the formula N = No(1 + r)^t where No is the initial size of the population, N is the final size of the population, r is the rate of growth or decay per time period, and t 
Physics
Calculate the period of the wave if it makes 10 vibrations in 2 seconds. Does anyone know the formula for this? frequency = (number of waves) divided by(observation time) = 10/2 = 5 Hertz period = 1/frequency = ? 
Physics
I got part a but I'm having trouble figuring out b... I know the formula should be something like: T=2pi/omega and omega=sqrt(k/m) but how am I supposed to find T when I don't know k or m?? A pendulum has a period of 2.4 s. a) 
Algebra
The formula T=2π√L/480 can be used to find the period (T in seconds, the time it takes a pendulum to complete one cycle) of a pendulum that is L cm long. (a)Rewrite this formula using rational exponents. Don't forget to 
PHYSiCS 
A pendulum makes 120 complete oscillations in 3.00 minutes at a location where g= 9.98m/s^2 Find the period of the period Find the length I tried using the 2pi sqrt. L/g formula I don't know why I got this huge number 
Math
Mathematicians have been searching for a formula that yields prime numbers. One such formula was x2  x+41. Select some numbers for x, substitute them in the formula,and see if prime numbers occur. Try to find a number for x that