answersLogoWhite

0

You should put the data into cells and use cell references in the formula. Then when the data changes, the formula will automatically recalculate based on the current data.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

How do you update a chart when add rows in source data?

Once data is added the chart will update itself, as long as the data being added is included in the data source for the chart. If the data source is extended, then the chart will automatically include the data.


What is the difference between data insert and data update?

Data insert is putting in new data, inserting it into the database. Data update is changing data that is already there, like putting in a new phone number for someone or giving every product an increased price.


What is the SQL data base material used for?

The SQL data base is programming language used to manipulate and retrieve data. Included in the language are elements such as data insert, query, update and delete.


How is an action query is different from select query?

Select queries do not change the data. They will show lists of data and various statistics and other requirements. Action queries do things like update records or delete records, which is changing the data. That is the difference.


What is adjusting in Microsoft Excel?

Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.Adjusting is changing things, so like changing data in cells or editing formulas.


How to Update data from jsp into database?

can i get update coding in jsp??


Which data will automatically update copied data?

after copying


What is a query that changes data called?

An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.An Update query.


Would my iPhone data erase when you update your iPhone?

Actually, It doesnt. 'Cause its the purpose of backing up the data. After the update, Your iphone will restore then it will put back your old data.


Is data comprehensiveness the quality characteristic for data when all data elements of the health record is included?

Data comprehensiveness is met when all data elements are included in the health record.


How do you update and delete data from PHP sessions?

To update/delete data from a session all you need to do is the following: <?php // to update the session, you just overwrite it like a normal variable $_SESSION['name'] = "pizza"; // to delete a sessions data you can do this $_SESSION['name'] = ""; ?>


What is edit in Excel?

It is changing the contents of the cell, like changing a formula or putting a new value in it. You can start editing by clicking on the content in the formula bar or pressing the F2 key.Cell editing is making any changes to the contents of the cell whether the contents is text, data (numbers) or a formula. Double click on a cell and you can edit it in the cell instead of on the formula bar.