Hi Clint,
It sounds like your Excel might be set to
manual calculation instead of automatic calculation. This means that Excel will not automatically recalculate formulas when you enter new data, but instead, you have to manually tell it to recalculate.
Here's how you can check if your Excel is set to manual calculation:
- Click on the "Formulas" tab in the ribbon at the top of Excel.
- Look for the "Calculation Options" section.
- If "Automatic" is not selected, click on it to switch to automatic calculation.
If this doesn't solve the problem, you can try the following:
- Select the entire column where your formula is located.
- Press F2 to enter edit mode for the cells.
- Press Ctrl + Enter to apply the formula to all selected cells.
This should force Excel to recalculate all the formulas in the selected column.