A cell in Excel contains 8 or 9 IF statements. The cell is returning #VALUE error; meaning there is a flaw in the formula. Is there a way to determine which part of the formula is being caculated without having to go through each IF statement one-by-one? I hope my question is clear. Any help would be great. Thanks.
Bookmarks