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.
To calculate the percentage in Quattro Pro based on your conditions, you can use a combination of IF statements, mathematical operations, and conditional formatting. Here's how you can achieve the desired results:
1. Percentage when B >= A:
- In an empty cell, enter the formula: =(B1/A1)*100
- Replace A1 with the cell reference of the base period number in column A, and B1 with the cell reference of the given number in column B.
- Format the cell as a percentage to display it as 50.0.
2. Negative percentage when B < A:
- In an empty cell, enter the formula: =((B2-A2)/A2)*100
- Replace A2 with the cell reference of the base period number in column A, and B2 with the cell reference of the given number in column B.
- Format the cell as a percentage to display it as -25.0.
To display the negative percentage in red:
- Select the cell with the negative percentage result.
- Go to the "Format" menu and choose "Conditional Formatting."
- Set up a rule to apply formatting when the cell value is less than 0.
- Choose the formatting option to display the text in red.
By following these steps, you should be able to calculate the desired percentages and display them as specified.