| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i enter a copy of a cell into another cell If 0
how do u copy cell A to cell B if cell C is 1
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i enter a copy of a cell into another cell If 0
Not sure if you mean "Copy"
This formula in B1 will display the value from A1 if C1 1 =IF(C11,A1,"") best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "fleety" wrote in message ... how do u copy cell A to cell B if cell C is 1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i enter a copy of a cell into another cell If 0
Try in B2: =IF(AND(ISNUMBER(C2),C21),A2,"")
Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "fleety" wrote: how do u copy cell A to cell B if cell C is 1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hit enter in cell & move text down in cell, not go to cell below. | Excel Worksheet Functions | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Make a sheet to enter score and score is copy to the proper cell.. | Excel Worksheet Functions | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| enter formula to copy characters in a cell less last one | Excel Discussion (Misc queries) | |||
Hybrid Mode
