| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying the data in and format of a cell to another cell | Excel Discussion (Misc queries) | |||
| When copying a cell to another cell the information is duplicated. | Excel Worksheet Functions | |||
| Copying format to a new cell, w/o overwriting destination cell contents | Excel Discussion (Misc queries) | |||
| copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
| Copying excel format from cell to cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
