Hi Bonnie,

To achieve the desired result, you can use the MIN function in Excel. Here's the formula you can use in cell Q32:

Let me explain how this formula works:

1. The IF function checks if Q31 is blank. If it is, then it returns the value in Q30. If not, it moves to the next part of the formula.
2. The MIN function compares the values in Q30 and Q31 and returns the lesser of the two.
3. The entire formula combines these two parts to give you the desired result.

You don't need to use an extra column for this. Simply enter the formula in cell Q32 and it will give you the result you need.