excel formula

Occasional Visitor

i have the same formula in a row in excel. every now and then there is a clear space in the data so there can't be anything calculated. in the place of the formula comes an error or 0,00 and i want that gone or else the other information isn't clear to see. how do i do that?

1 Reply

@gylene_jong Look into using ISBLANK and/or IFERROR. In Dutch that would be ISLEEG and/or ALS.FOUT