• zero if error #N/A
    Useful formulas

    Zero if error or #N/A in Vlookup

    Sometimes the result of an excel formula is an element of a larger and sophisticated calculation which will end displaying an error if any of the elements taken into account is not a number. This is the case of #N/A…