However, if the formula results in an error, IFERROR "takes over" and produces an alternative result. The idea is that your formula would work as it normally does when there are no errors to return. IFERROR can be used to eliminate formula errors and replace those errors with something else. Is there a way to have Excel automatically return something instead of an error?Ī. I have an Excel spreadsheet that contains errors because some of the numbers that are part of the calculations are blank or zero.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |