Software

Ask something
Discussion Locked

Division formula in Access

0 helpful
5 replies

by mack_shane

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

5 replies

by mack_shane

Thanks for the help. This formula worked with a few minor changes.

=IF(ISERROR(G15/F15),0,(G15/F15))

Thanks

This discussion is closed to new replies.