Help w/Quattro Formula
posted by Al .
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.
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 %? 
Physics
Calculate the period of the wave if it makes 10 vibrations in 2 seconds. Does anyone know the formula for this? 
Chemistry
If you divide the molar mass of a compound by the empirical formula mass, what is the result? 
math
In the formula s=ut+1/2at square.Make a the subject of formula (b)find the values ot t when s=42,u=2 and a=8.Am getting difficulties in that number. 
Algebra
I have two problems that I am not sure about how to work out. 1. The distance traveled by a falling object is given by the formula d=4.9t^2, where d is in meters and t is in seconds. Solve the formula for t. 2.The volume of a right … 
ALGEBRA
I have two problems that I am not sure about how to work out. 1. The distance traveled by a falling object is given by the formula d=4.9t^2, where d is in meters and t is in seconds. Solve the formula for t. 2.The volume of a right … 
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 harmonic … 
trig
list the period, amplitude, interval, and phase shift of: g(t)=5/2sintpi i know the amplitude is 5/2 but everything else im not getting. the regular formula for these is y=Asin(Bx+C)+D A is the amplitude B is the period which you … 
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 is … 
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 …