How to write for copying a cell value to another cell

C

Chiropter

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?
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COMPARING TWO COLUMNS AND DISPLAYING MSGBOX 6
Excel In Excel how can I block the contenent of a cell? 0
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
SUMIF "value if false" not working 2
Conditional Formatting and cloring cells and date calculations 1
if one cell were to equal __ what would the value in another cell 2
setting cell values based on a 3rd cell 4
reffering another cell value which contains RAND() 0

Top