0
In excel if you input a value in a cell how do you get it to copy to another CELL depending on a certain value?
Wiki User
∙ 14y ago
You can not "push" a value from one cell to another cell without writing a specifc macro to do the task. You need to "pull" the value. If you want to copy the value from A1 to B1 if the value of A1 is greater than 6, put the following formula in B1:
=IF(A1>6,A1,"")
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Which Excel feature can be utilized to only allow the input of certain data such as dates times or numbers?
Validation is the feature that can limit what is entered into cells in Excel.
How do you input the marginal product equation in excel?
how do you find marginal product on excel
What is Cell for excel?
the box into which you input data
How do you link cells in excel so that when one word is input in one cell automatically input in a different cell?
in cell B1 put +A1
How do you input and manipulate the data entered into data management software P5?
you can input and manipulate data in microsoft excel. :) hope that helps, good luck!
What are audio adapters used for?
Audio adapters are used for converting a plug into another style of plug. Audio adapters simply help one change the input plug of a certain system to a different input plug.
How to calculate IC 50 value using Excel?
ED50V10 (Readme) is an Excel add-in for calculating IC50/EC50 values. Input your data in the left columns, and your results will be shown in the right half of the Excel table. To calculate IC50, input 50 in the "INTERPOLATE..." table (highlighted in blue), the result will be shown on the right (highlighted in green).
How do you calculate air compressor capacity?
Flow rate times pressure divided by input will yield air compressor capacity. Input is another term for horsepower of the compressor. The pressure can be adjusted depending on how compact the result is to be.
What data types can be input into Microsoft Excel 2000 Spreadsheets?
text and numbers formatted in a variety of ways
What does the D 15 in the Excel formula C5D15 stand for?
those are just the coordinates of the box it is taking input from.
What duties are incuded in a clinical data job?
The majority of the work is the input. You'll need to know how to use an Excel spreadsheet from Microsoft office to input data from the clinic you work for.
Which tool in Excel should you use if you know the answer but you don't know the input value?
You would use Goal Seek.
