55.5k views
4 votes
What mistake do you think you might make related to changing the data in a cell that's used in a formula?

User Amila
by
4.5k points

1 Answer

2 votes

Answer

Hi,

The mistake could be the #DIV/0! error , or a #REF! error

Step-by-step explanation

When changing the data in a cell that’s used in a formula, a #DIV/0! Error can occur when the formula attempts to divide a number by 0 or an empty cell. To rectify this, you will need to change the value of that cell to a value not equal to 0. In some cases, the #REF! error could be displayed. This means that the formula refers to a cell that is not valid.

Hope this Helps!

User Cezary Baginski
by
5.2k points