This would be in cell a1. To clear the values I clear just cells b1 and c1. Of course that may result in some ERR! being shown in a1 but that's proper.
iMac 0s10.6.8 Office, Microsoft Excel 2011 - I have a spreadsheet that I used last year for tax information. I would like to use the same spreadsheet this year but I can not clear the cells without removing the formulas as well. Does anyone know what I need to do.. I have followed the directions that I have found and tried all ways but still no success.