how do i enter a copy of a cell into another cell If > 0

[Guest]

how do u copy cell A to cell B if cell C is >1

 

[Bernard Liengme]

Not sure if you mean "Copy"
This formula in B1 will display the value from A1 if C1 > 1
=IF(C1>1,A1,"")
best wishes

 

[Guest]

Try in B2: =IF(AND(ISNUMBER(C2),C2>1),A2,"")
Copy down