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