Help

[Daniel07ra]

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.

[#2]

#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).