ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to write for copying a cell value to another cell (https://www.excelbanter.com/excel-worksheet-functions/133185-how-write-copying-cell-value-another-cell.html)

Chiropter

How to write for copying a cell value to another cell
 
This might be a beginner's question, but help me.
I want to instruct a cell to copy the value in a certain cell to another
specified cell.
For example, Cell A1's task is
1. To see if cell B1 has a numeric value
2. If B1's value is greater than a specific number
3. copy the value to C1
4. If B1's value is less than the specified number
5. do nothing
What shall I write in A1?

joel

How to write for copying a cell value to another cell
 
Excel doesn't allow you to copy to a cell. A cell doesn't have any tasks
associate with them. that value that goes into a cell is based solely on a
fomula generated in the cell that cell

C1 would have a formula would have an If function looking at B1's value.

In cell C1 - If B1 is greater than 3 put 1 in C1. Otherwise put 0 in C1.
=if(B1 3,1,0)

"Chiropter" wrote:

This might be a beginner's question, but help me.
I want to instruct a cell to copy the value in a certain cell to another
specified cell.
For example, Cell A1's task is
1. To see if cell B1 has a numeric value
2. If B1's value is greater than a specific number
3. copy the value to C1
4. If B1's value is less than the specified number
5. do nothing
What shall I write in A1?



All times are GMT +1. The time now is 11:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com