Hiding the formula in Excel
Posted by David Snedeker on August 27, 2001 6:41 PM
I have designed a very simple spreadsheet that will tell me how many reservations to calls my reps have taken.
The formula is =SUM(C5/C4) and so on down the row. I am getting the message #DIV/0! which I know indicates that I am dividing by a divisor of 0 I think or something like that. I am fine with that. I just need to kow how to hide what that shows because I will be placing numbers in the 2 cells before it to properly let it divide. But in the meantime it will be 0. How do I hide #DIV/0!