Forum Discussion

ccalvo's avatar
ccalvo
Copper Contributor
Jan 16, 2020

DESBORDAMIENTO

Necesitaría saber como deshabilitar el autocompletado cuando introduzco una fórmula (me ocurre desde hace un mes) y porque sale a veces "Desbordamiento" .

La fórmula es Buscarv

Gracias

3 Replies

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor

    ccalvo 

    You need to put a lid on the formula so it doesn't spill.


    Excel is telling you the formula is producing multiple results.

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor

        ccalvo 

        Please post some examples of the formulas that are spilling or producing SPILL (I think it appears as OVERFLOW in your version) errors.

Resources