Monday
August 31, 2015

Homework Help: Help w/Quattro Formula

Posted by Al on Thursday, July 20, 2006 at 11:39am.

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 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.)

I'd sure appreciate your help. Thanks.

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

More Related Questions

Members