Sep 23 2022 03:16 AM
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?
Sep 23 2022 03:31 AM
@gylene_jong Look into using ISBLANK and/or IFERROR. In Dutch that would be ISLEEG and/or ALS.FOUT