Excel 2003 Does someone have an easy way to not display formulas where data has not been entered?
I created an Excel file to track the percentage of the number of participants scheduled as opposed to those who actually appeared. One column contains the formula. Obviously, the figures for April, May, June have not been entered, but the formula displays in the percentage column. Without having to go through the rigamarole of protection, locking, etc. - is there a less complicated way to have the percentage appear empty - but have the percentage display when later figures are entered. I will be grateful for any help on this. I've searched a couple of books but have not found a spelled-out description. Thank you.