| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Something like ..
In B20: =IF(A19="Yes",A20,"") B20 will return the contents of A20 if A19 contains the word: Yes, otherwise blank: "" will show in B20 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- wrote in message ... How can I copy data from one cell to another only if a certain criteria is met using the IF function? For example, I want to copy data from cell A20 if the cell A19 the a specific word in it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i use the function to copy and paste a determined variable. | Excel Worksheet Functions | |||
| Does anyone have a copy of the Peter Noneley: Function list? | New Users to Excel | |||
| copy a cell value not its function | Excel Discussion (Misc queries) | |||
| Copy an IF function when Inserting new row | Excel Discussion (Misc queries) | |||
| Need Help to Prevent Copy Function Use in a Read-Only Workbook | Excel Worksheet Functions | |||
Hybrid Mode
