answersLogoWhite

0


Best Answer

The formula that you have in D1 can be copied down to D2 and down beyond that to the other cells below it to do whatever calculation you are doing. You can use the Fill Handle to do it quickly. Select cell D1. Put the cursor over the bottom right corner until you see a solid black cross. Then click and drag down.

User Avatar

Wiki User

9y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: I have data in A1 B1 C1 If I have an equation that shows results in D1 how do I make it so the equation automatically calculates for results in each row eg A2 B2 C2 and D2 contains row 2 data?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What equation results from completing the square and then factoring?

A quadratic equation


What is the difference between integration and derivation?

Integration results in an equation which gives the area under the original equation between the bounds. Derivation results in an equation which gives the slope of the original line at any point.


How is a wind vane used for forecasting?

It is recorded automatically and mixed in with other results from the weather station.


When is an a automatically liable for harassment by a supervisor?

When the harassment results in a tangible employment action regardless of whether upper management had knowledge of it is when an agency is automatically liable for harassment by a supervisor.


When can two equations be equal?

Two equations are equal when the result of the functions of the numbers and variables of one equation match the results of the other equation.


When is an agency automatically liable for harassment by a supervisor?

When the harassment results in a tangible employment action regardless of whether upper management had knowledge of it is when an agency is automatically liable for harassment by a supervisor.


What is the property that you can subtract the same number from both sides of an equation the new equation will have the same solution?

The property is: If equals are subtracted from equals, the results are equal.


The value for a variable that results in a true sentence?

That's the "solution" to the equation described by the sentence.


What is the value for a variable that results in a true sentence?

That's the "solution" to the equation described by the sentence.


What does Excel use to automatically to modify values?

Formulas will change their results as other things change in a spreadsheet.


Is there a way of having online survey results automatically fed into a database on submission?

Yes, you can set up a process that integrates your online survey tool with a database system. Many survey tools offer this feature through third-party integrations or API connections that can automatically populate the database with survey responses upon submission. This helps streamline the data collection process and keeps your database up-to-date in real-time.


What equation results from completing the square and then factoring x2-8x39?

(X-4)^2=55