I have a cell which is dividing two other cells eg. H15 =(G15/F15). If the cells don’t contain any data #DIV/0! is displayed in H15. At the moment #DIV/0! is displayed all through the document as the cells won’t be filled until a later stage due to the document being a budget.
Is there any way to hide the formual error #DIV/0! from displaying?
Thanks.