In my Excel 2007 spreadsheet, I have the following two formulas:
in Column Q: =(D34-D$23)/D$23*100
in Column P: =(D34-D33)
When I enter a number in cell D35, the cell Q35 automatically calculates even though no formula has been entered in that cell previously, but cell P35 remains empty. How can I get the cells in Column P to auto calculate like the ones in Column Q?
Thank you for your help!
in Column Q: =(D34-D$23)/D$23*100
in Column P: =(D34-D33)
When I enter a number in cell D35, the cell Q35 automatically calculates even though no formula has been entered in that cell previously, but cell P35 remains empty. How can I get the cells in Column P to auto calculate like the ones in Column Q?
Thank you for your help!