To alter the mistake display, find the For mistake values show Examine box. While in the box, variety the worth you want to display as an alternative to errors. To display faults as blank cells, delete any characters while in the box.Test to check out In the event the values returned by a formula have improved If the information that you have sorte