Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2014683%22%20slang%3D%22es-ES%22%3EHelped%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2014683%22%20slang%3D%22es-ES%22%3E%3CP%3EYou%20know%20how%20to%20fix%20that%20REFF%20thing%20I%20don't%20know%20what%20to%20do%20anymore%20and%20I'm%20just%20learning%20to%20use%20excel%20and%20I%20don't%20know%20what%20happens.%20I'm%20with%20a%20few%20exercises%20the%20idea%20is%20that%20I%20get%20the%20result%20of%20the%20formula%20that%3C%2FP%3E%3CP%3Elooks%20like%20upstairs.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2014683%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2014792%22%20slang%3D%22en-US%22%3ERE%3A%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2014792%22%20slang%3D%22en-US%22%3E%23REF%20occurs%20when%20the%20formula%20references%20something%20that%20has%20been%20deleted%20(cell%2C%20range%2C%20name%2C%20etc.).%20For%20example%2C%20say%20cell%20C1%20is%20linked%20to%20cell%20A1%20with%20the%20formula%20%3DA1.%20Then%2C%20you%20delete%20column%20A%20by%20right%20clicking%2C%20delete%2C%20entire%20column.%20Because%20you%20deleted%20the%20entire%20column%2C%20instead%20of%20just%20deleting%20the%20contents%2C%20you%20would%20then%20get%20a%20%23REF%20error%20in%20cell%20C1%20(which%20is%20now%20B1%20because%20it%20shifted%20to%20the%20left%20when%20column%20A%20was%20deleted).%3C%2FLINGO-BODY%3E
Occasional Visitor

Ustedes saben como arreglo eso de #REF! ya no se que hacer y estoy apenas aprendiendo a usar excel y no se que pasa. Estoy con unos ejercicios la idea es que me aparezca el resultado de una formula =$A2*D$6 en la celda superior pero todo la fila superior me sale #REF! y no se como arreglarlo por que ne otras filas si aparece.

1 Reply
#REF occurs when the formula references something that has been deleted (cell, range, name, etc.). For example, say cell C1 is linked to cell A1 with the formula =A1. Then, you delete column A by right clicking, delete, entire column. Because you deleted the entire column, instead of just deleting the contents, you would then get a #REF error in cell C1 (which is now B1 because it shifted to the left when column A was deleted).